[Oracle] 월 시작일 / 종료일 ( Month Start day/Last day )

SELECT TRUNC(SYSDATE, 'MM') AS month_start FROM DUAL;

SELECT LAST_DAY(SYSDATE) AS month_start FROM DUAL;

 

SELECT TO_CHAR(TRUNC(SYSDATE, 'MM'),'YYYY-MM-DD') AS month_start FROM DUAL;

SELECT TO_CHAR(LAST_DAY(SYSDATE),'YYYY-MM-DD') AS month_start FROM DUAL;

 

끝