SELECT SYSDATE CURRENT_DT,
TRUNC(SYSDATE,'MM') MONTH_BEGIN,
ADD_MONTHS(TRUNC(SYSDATE,'MM'),1)-1 MONTH_END
FROM DUAL;
Oracle 获取月初和月末
All for u
SELECT SYSDATE CURRENT_DT,
TRUNC(SYSDATE,'MM') MONTH_BEGIN,
ADD_MONTHS(TRUNC(SYSDATE,'MM'),1)-1 MONTH_END
FROM DUAL;