SELECT SYSDATE CURRENT_DT,
TRUNC(SYSDATE,'MM') MONTH_BEGIN,
ADD_MONTHS(TRUNC(SYSDATE,'MM'),1)-1 MONTH_END
FROM DUAL;
SELECT SYSDATE CURRENT_DT,
TRUNC(SYSDATE,'MM') MONTH_BEGIN,
ADD_MONTHS(TRUNC(SYSDATE,'MM'),1)-1 MONTH_END
FROM DUAL;
转载于:https://www.cnblogs.com/ayumie/p/9633260.html