WEEK (Lakehouse v2)

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