Oracle的TimeStamp型字段问题(50分)

S

steel

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #1

[?]若表Tab1的字段F1为TimeStamp型，下面语句如何才对？
select * from Tab1 where F1 between '2002-9-9' and '2002-10-9'

 

G

gigiiou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #2

select * from Tab1 where F1 between to_date('2002-9-9') and to_date('2002-10-9')

 

老

老人家

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #3

同意

 

S

steel

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #4

to gigiiou:
不行啊！错误信息： ORA-01861: 文字与格式字符串不匹配

 

G

gigiiou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-14

• #5

steel:
to_date的表示不对,呵呵~对不起那条我也没有测试过,应该这样的:
select * from Tab1 where F1
between to_date('2002-9-9','yyyy-mm-dd')
and to_date('2002-10-9','yyyy-mm-dd')

 

S

steel

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-14

• #6

接受答案了.