WEEK

Learn how to use the WEEK date/time function in PlaidCloud Lakehouse. Returns the week number of the year for a date - see syntax, examples, and output.

Returns the week number of the year for a date.

Analyze Syntax

func.week(<date>[, <mode>])

Analyze Examples

func.week('2024-06-15')

┌────┐
│ 24  │
└────┘

SQL Syntax

WEEK(<date>[, <mode>])

SQL Examples

SELECT WEEK('2024-06-15');

┌────┐
│ 24  │
└────┘