转自:https://www.2cto.com/database/201310/249009.html
1、本月第一天
SELECT
TRUNC (SYSDATE, 'mm')
FROM
dual
SELECT TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE, -2)) + 1,'YYYYMMDD') FROM DUAL;
2、本月最后一天
SELECT TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE, -1)),'YYYYMMDD') FROM DUAL;