YEARWEEK (Lakehouse v2)

Returns the year and week number for a date as an integer.

Analyze Syntax

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

Analyze Examples

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

┌────────┐
│ 202424  │
└────────┘

SQL Syntax

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

SQL Examples

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

┌────────┐
│ 202424  │
└────────┘