问题:delete from jf_syslog where inputtime between '2011-07-01' and '2011-07-05' 这句话只能删除2011-07-05之前的不能删除2011-07-05的。什么方法能删除2个条件之间的?
答案:
delete from jf_syslog where to_date(inputtime,'yyyy-mm-dd') between to_date('2011-07-01','yyyy-mm-dd') and to_date('2011-07-05' ,'yyyy-mm-dd')