LAST_DAY

Returns the last day of the specified interval (week, month, quarter, or year) based on the provided date or timestamp.

Syntax

LAST_DAY(<date_expression>, <date_part>)

Return Type

Date.

Examples

Let's say you want to determine the billing date, which is always the last day of the month, based on an arbitrary date of a transaction (e.g., 2024-11-13):

SELECT LAST_DAY(to_date('2024-11-13'), month) AS billing_date;

┌──────────────┐
│ billing_date │
├──────────────┤
│ 2024-11-30   │
└──────────────┘