oracle查询上个月的数据(或者某个月)

select * from table_name where 时间字段 between to_date(to_char(add_months(sysdate,-1),'YYYY-MM') ||'-01 00:00:00','YYYY-MM-DD HH24:MI:SS') 
and to_date(to_char(last_day(add_months(sysdate,-1)),'YYYY-MM-DD') ||'23:59:59','YYYY-MM-DD HH24:MI:SS')

或者

SELECT to_date(to_char(last_day(add_months(sysdate, -2)) +1, 'yyyy-MM-dd') ||' 00:00:00', 'yyyy-mm-dd HH24:MI:SS'),
to_date(to_char(last_day(add_months(sysdate, -1)), 'yyyy-MM-dd') ||' 23:59:59', 'yyyy-mm-dd HH24:MI:SS') from dual

查询某个月

SELECT to_date('202006','yyyy-MM'),last_day(to_date('202006','yyyy-mm'))+1 from dual