根据日期查询范围 精确到天 select * from table where to_char( time,'yyyy mm dd ' ) <= '2000 01 01'
select * from table where to_char( time,'yyyy-mm-dd ' ) <= '2000-01-01'
select * from table where to_char( time,'yyyy/mm/dd ' ) <= '2000/01/01' 精确到秒 select * from table where to_char( time,'yyyy mm dd hh24 mi ss' ) <= '2000 01 01 12 12 12'
select * from table where to_char( time,'yyyy-mm-dd hh24-mi-ss' ) <= '2000-01-01 12-12-12'
select * from table where to_char( time,'yyyy/mm/dd hh24:mi:ss' ) <= '2000/01/01 12:12:12'
|