1，sysdate就是系统当前时间，也是date类型的 2，select * from 表名 where to_char(slrq,'yyyy-mm-dd') between '2014-07-01' and '2014-07-23'select * from 表名 where to_char(slrq,'yyyy-mm-dd hh24:mi:ss') between '2014-07-01 00:00:00' and '2014-07-23 23:59:59'...
where sysdate>'2011-8-1' and sysdate<'2011-8-10' 或者 where datediff(day,sysdate,'2011-8-1')>0 and datediff(day,sysdate,'2011-8-10')<=0
sysdate - to_date(数字,'hh24')数字最好是number类型的