[Oracle] - LAST_DAY()

LAST_DAY()

- Syntax

LAST_DAY(DATE)

- Purpose

LAST_DAY returns the date of last day of month that contains date

- Example

SELECT SYSDATE,
   LAST_DAY(SYSDATE) "Last",
   LAST_DAY(SYSDATE) - SYSDATE "Days Left"
   FROM DUAL;