Categories:: Date & time functions

LAST_DAY¶

Returns the last day of the specified date part for a date or timestamp. This function is commonly used to return the last day of the month for a date or timestamp.

See also:: NEXT_DAY , PREVIOUS_DAY

Syntax¶

LAST_DAY( <date_or_timetamp_expr> [ , <date_part> ] )

Copy

Arguments¶

date_or_timestamp_expr: A date or a timestamp, or an expression that can be evaluated to a date or a timestamp.

date_part

The date part for which the last day is returned. Possible values are year, quarter, month, or week (or any of their supported variations). For more information, see Supported date and time parts.

When date_part is week (or any of its variations), the output is controlled by the WEEK_START session parameter. For more details, including examples, see Calendar weeks and weekdays.

For more information, including examples, see Calendar weeks and weekdays.

Default: month

Returns¶

This function returns a value of type DATE, even if date_or_timetamp_expr is a timestamp.

Examples¶

Return the last day of the month for the specified date (from a timestamp):

SELECT TO_DATE('2025-05-08T23:39:20.123-07:00') AS "DATE",
       LAST_DAY("DATE") AS "LAST DAY OF MONTH";

Copy

+------------+-------------------+
| DATE       | LAST DAY OF MONTH |
|------------+-------------------|
| 2025-05-08 | 2025-05-31        |
+------------+-------------------+

Return the last day of the year for the specified date (from a timestamp):

SELECT TO_DATE('2024-05-08T23:39:20.123-07:00') AS "DATE",
       LAST_DAY("DATE", 'year') AS "LAST DAY OF YEAR";

Copy

+------------+------------------+
| DATE       | LAST DAY OF YEAR |
|------------+------------------|
| 2024-05-08 | 2024-12-31       |
+------------+------------------+