系统时间上一天
select to_char(sysdate-1,'yyyymmdd') from dual;
系统时间上一个月
select to_char(add_months(sysdate,-1),'yyyymm') from dual;
转载于:https://blog.51cto.com/6205526/1100713
转载于:https://blog.51cto.com/6205526/1100713