LAST_DAY – Oracle SQL Function

LAST_DAY returns the last day of the month specified in argument1.

Argument1 can be a DATE value or a string that can resolve to a DATE datatype.

Example:

SELECT LAST_DAY(’12-OCT-04′) as RESULT from DUAL;

RESULT
—————
31-OCT-04