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.
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
This function returns a value of type DATE, even if date_or_timetamp_expr is a timestamp.
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 | +------------+------------------+
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4