可以先查询一下:select * FROM TB WHERE 时间字段<='2013-09-01'看有没有,如果有的话:DELETE FROM TB WHERE 时间字段<='2013-09-01'如果没有查询到数据,可能需要把时间字段格式给修改一下: select * FROM TB WHERE 时间字段<=to_date('yyyy-mm-dd','2013-09-01')
select * FROM TB WHERE 时间字段<=to_date('yyyy-mm-dd','2013-09-01')
delete from A表 where [字段]<to_date('2013-09-01','yyyy-mm-dd');commit;
select * FROM TB WHERE 时间字段<=to_date('yyyy-mm-dd','2013-09-01')
delete from A表
where [字段]<to_date('2013-09-01','yyyy-mm-dd');commit;