查一个月前:
select add_months(sysdate,-1) from dual
查两天前
select sysdate-2 from dual
删除一个月前的数据:
delete from MQ_RECORD where createtime < add_months(sysdate,-1)
查一个月前:
select add_months(sysdate,-1) from dual
查两天前
select sysdate-2 from dual
删除一个月前的数据:
delete from MQ_RECORD where createtime < add_months(sysdate,-1)