PREVIOUS_DAY

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>)

Parameter	Description
`<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  │
└─────────────┘