OracleDate/Time FunctionsLAST_DAY
MONTHS_BETWEEN

LAST_DAYDate/Time Functions

NEXT_DAY

Returns the last day of the month.

Syntax

LAST_DAY(date)

Example

Enter values below to update the example in real time.

month_end
SELECT LAST_DAY(SYSDATE) AS month_end FROM DUAL;