Skip to content

Latest commit

 

History

History
58 lines (41 loc) · 819 Bytes

File metadata and controls

58 lines (41 loc) · 819 Bytes
description
This section contains reference documentation for the yearOfWeek function.

yearOfWeek

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