LAST_DAY

LAST_DAY returns the last day of the month in which a particular date falls.

Return Value

DATE

Syntax

LAST_DAY(date)

Arguments

date can be any datetime expression.

Example

LAST_DAY('26-MAR-06') returns the value 31-MAR-06.