PREVIOUS_DAY

Learn how to use the PREVIOUS_DAY datetime function in PlaidCloud Lakehouse. Returns the date of the most recent specified day of the week before the given...

Returns the date of the most recent specified day of the week before the given date or timestamp.

Analyze Syntax

func.next_day(date_expression>, <target_day>)

Analyze Examples

func.next_day(func.to_date('2024-11-13'), 'friday')
┌──────────────────────────────────────────────────────┐
│ func.next_day(func.to_date('2024-11-13'), 'friday')  │
├──────────────────────────────────────────────────────┤
│ 2024-11-08                                           │
└──────────────────────────────────────────────────────┘

SQL Syntax

PREVIOUS_DAY(<date_expression>, <target_day>)
ParameterDescription
<date_expression>A DATE or TIMESTAMP value to calculate the previous occurrence of the specified day.
<target_day>The target day of the week to find the previous occurrence of. Accepted values include monday, tuesday, wednesday, thursday, friday, saturday, and sunday.

Return Type

Date.

SQL Examples

If you need to find the previous Friday before a given date, such as 2024-11-13:

SELECT PREVIOUS_DAY(to_date('2024-11-13'), friday) AS last_friday;

┌─────────────┐
│ last_friday │
├─────────────┤
│ 2024-11-08  │
└─────────────┘