请问oracle里日期怎么用SQL语句进行筛选啊

[liangqihui999]

刚刚用oracle，请问oracle里日期怎么用SQL语句进行筛选啊

[iwantsay]

to_date('2003/03/03 12:12:12','YYYY/MM/DD ')

[lianhg]

select * from tbl where datefld > sysdate -- or = sysdate
select * from tbl where to_char(datefld,'YYYY/MM/DD') > '2003/12/24'

[iwantsay]

to_char(datefield,'yyyy/mm/dd')

[beckhambobo]

select * from tabname where col_date between to_date('2003-11-11 08:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2003-11-11 23:30:00','yyyy-mm-dd hh24:mi:ss')