select to_char(add_months(trunc(sysdate),-1),'yyyymm') from dual;字符串格式为YYYYMM
select to_char(add_months(to_date('202004'||'01','YYYY-MM-DD'),-1),'yyyymm') from dual;
SELECT add_months(trunc(sysdate),-1) FROM DUAL;日期格式
select to_char(add_months(trunc(sysdate),-1),'yyyymm') from dual;字符串格式为YYYYMM
select to_char(add_months(to_date('202004'||'01','YYYY-MM-DD'),-1),'yyyymm') from dual;
SELECT add_months(trunc(sysdate),-1) FROM DUAL;日期格式