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
select yearOfWeek(1609731386000, 'America/Toronto') AS year
FROM ignoreMe
select yow(1609731386000) AS year
FROM ignoreMe
select yow(1609731386000, 'America/Toronto') AS year
FROM ignoreMe