返回月初1号:
Select trunc(add_months(sysdate,0),'mm') from dual;
返回次月1号:
Select trunc(add_months(sysdate,1),'mm') from dual;
系统时间加1个月:
select to_char(add_months(sysdate,1),'yyyymm') from dual;
Select trunc(add_months(sysdate,0),'mm') from dual;
Select trunc(add_months(sysdate,1),'mm') from dual;
select to_char(add_months(sysdate,1),'yyyymm') from dual;