select * from tbl where datefld > sysdate -- or = sysdate select * from tbl where to_char(datefld,'YYYY/MM/DD') > '2003/12/24'
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')
select * from tbl where to_char(datefld,'YYYY/MM/DD') > '2003/12/24'