LAST_DAY_OF_MONTH

​

Syntax

​

Scalar

last_day_of_month(value)

​

Arguments

​

Returns

• Type: DATE
• NULL behavior: NULL value yields NULL. Unrepresentable calendar dates raise an error.

​

Properties

​

Usage notes

• Inputs are converted to DATE before finding the last day of the month.

​

Examples

​

Basic example

SELECT last_day_of_month(DATE '2024-02-15') AS result;

​

Leap years and ordinary years

SELECT last_day_of_month(DATE '2023-02-15') AS ordinary_year, last_day_of_month(DATE '2024-02-15') AS leap_year;

​

Limitations

• Use DATE values or the TIMESTAMP conversions shown here. TIME inputs are outside these forms.