YEARWEEK

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