Oracle LAST_DAY

Function Description

Function LAST_DAY returns the last date of the month in DATE datatype.

Examples

SELECT SYSDATE,
       LAST_DAY(SYSDATE) "LAST DAY OF MONTH"
  FROM dual;

Result: SYSDATE     LAST DAY OF MONTH
        15.11.2011  30.11.2011