获取上个月
select to_char(add_months(trunc(sysdate),-1),'yyyymm') F_DATE from dual;
获取下个月
select to_char(add_months(trunc(sysdate),1),'yyyymm') from dual;
获取上个月
select to_char(add_months(trunc(sysdate),-1),'yyyymm') F_DATE from dual;
获取下个月
select to_char(add_months(trunc(sysdate),1),'yyyymm') from dual;