YEARWEEK

Learn how to use the YEARWEEK date/time function in PlaidCloud Lakehouse. Returns the year and week number for a date as an integer - with syntax and examples.

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