LAST_DAY

Learn how to use the LAST_DAY datetime function in PlaidCloud Lakehouse. Returns the last day of the specified interval (week, month, quarter, or year)...

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

Analyze Syntax

func.last_day(<date_expression>, <interval>)

Analyze Examples

func.last_day(func.to_date('2024-11-13'), 'month')
┌──────────────────────────────────────────────────────┐
│ func.last_day(func.to_date('2024-11-13'), 'month')   │
├──────────────────────────────────────────────────────┤
│ 2024-11-30                                           │
└──────────────────────────────────────────────────────┘

SQL Syntax

LAST_DAY(<date_expression>, <interval>)
ParameterDescription
<date_expression>A DATE or TIMESTAMP value to calculate the last day of the specified interval.
<interval>The interval type for which to find the last day. Accepted values are week, month, quarter, and year.

Return Type

Date.

SQL 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   │
└──────────────┘