select * from table1 where date1 >= trunc(add_months(sysdate,-1)) and date1 < trunc(sysdate);
--上个月: SELECT * FROM table_name WHERE dt BETWEEN Trunc(add_months(SYSDATE,-1),'mm') AND Last_Day(Trunc(SYSDATE,'mm')); --前两个月: SELECT * FROM table_name WHERE dt BETWEEN Trunc(add_months(SYSDATE,-2),'mm') AND Last_Day(Trunc(SYSDATE,'mm'));
where to_char(dt,'yyyymm')=to_char(add_months(sysdate,-1),'yyyymm')
select * from tb where to_char(sysdate,'MM')-1=to_char(你的时间字段,'MM');
where date1 >= trunc(add_months(sysdate,-1)) and date1 < trunc(sysdate);
SELECT * FROM table_name WHERE dt BETWEEN Trunc(add_months(SYSDATE,-1),'mm') AND Last_Day(Trunc(SYSDATE,'mm'));
--前两个月:
SELECT * FROM table_name WHERE dt BETWEEN Trunc(add_months(SYSDATE,-2),'mm') AND Last_Day(Trunc(SYSDATE,'mm'));
from tb
where to_char(sysdate,'MM')-1=to_char(你的时间字段,'MM');