Skip to content

YEARWEEK

YEARWEEK(timestamp_val)

Returns the year and week number for the provided timestamp_val concatenated as a single number. For example: 

YEARWEEK(TIMESTAMP '2021-08-30::00:00:00')
202135