MONTHS_BETWEEN
LAST_DAY
NEXT_DAY
Returns the last day of the month.
LAST_DAY(date)
Enter values below to update the example in real time.
month_end
SELECT LAST_DAY(SYSDATE) AS month_end FROM DUAL;