oracle下按日期删除记录

Question

delect  from table_name where to_char(access_data,'yyyy-mm')='2003-01'

Answer 1

delete tablename where to_char(access_date,'yyyy-MM')='2003-01'

Answer 2

delete from table where trunc(access_date,'mm')=to_date('2003-1','yyyy-mm');

Answer 3

delete from tname where to_char(access_date,'yyyymm')='200301';

Answer 4

我也来得分
delete from tname where to_char(access_date,'yyyymm')='200301'

Answer 5

delete from tname where access_date-to_date('2002-01-01','yyyy-mm-dd')<20 and access_date-to_date('2002-01-01','yyyy-mm-dd')>=0

Answer 6

delete tname where to_char(access_date,'YYYYMMDD')<='20031020' and
to_char(access_date,'YYYYMMDD')>='20030101';