sql for first day of month and last day of month
select SYSDATE , last_day(sysdate) as LAST_DATE_CURR_MNTH, ADD_MONTHS(last_day(sysdate),-1) as PREVIOUS_MON_LAST_DATE, last_day(sysdate)+1 as NEXT_MON_FIRST_DATE, ADD_MONTHS(last_day(sysdate),+1) as NEXT_MON_LAST_DATE, ADD_MONTHS(last_day(sysdate),+5) as LAST_DATE_OF_5TH_MON, ADD_MONTHS(last_day(sysdate),+5) +1 as FIRST_DATE_IN_6TH_MON_AFTR_NOW from dual; "SYSDATE" "LAST_DATE_CURR_MNTH" "PREVIOUS_MON_LAST_DATE" "NEXT_MON_FIRST_DATE" "NEXT_MON_LAST_DATE" "LAST_DATE_OF_5TH_MON" ----------- --------------------- ------------------------ --------------------- -------------------- ----------------------- "FIRST_DATE_IN_6TH_MON_AFTR_NOW" ----------------------- 01-APR-16 30-APR-16 31-MAR-16 ...