WEEKOFYEAR (Lakehouse v2)

Returns the week of the year for a date. Alias for WEEK.

Analyze Syntax

func.weekofyear(<date>)

Analyze Examples

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

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

SQL Syntax

WEEKOFYEAR(<date>)

SQL Examples

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

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