yearOfWeek

This section contains reference documentation for the yearOfWeek function.

Returns the year of the ISO week from the given epoch millis and timezone id. Alias yowis also supported.

Signature

yearOfWeek(tsInMillis)

yearOfWeek(tsInMillis, timeZoneId)

yow(tsInMillis)

yow(tsInMillis, timeZoneId)

Usage Examples

select yearOfWeek(1609731386000) AS year
FROM ignoreMe

year
2021

select yearOfWeek(1609731386000, 'America/Toronto') AS year
FROM ignoreMe

year
2020

select yow(1609731386000) AS year
FROM ignoreMe

year
2021

select yow(1609731386000, 'America/Toronto') AS year
FROM ignoreMe

year
2020