First, last day of the month Oracle

Oracle > Date & Time > First day and last day of the month Oracle

SELECT (trunc(sysdate, 'mm')) first_day FROM dual;

SELECT last_day(trunc(sysdate)) last_date FROM dual;

--result

FIRST_DAY
-----------
12/1/2010

LAST_DATE
-----------
12/31/2010