Apache Pinot Docs
latest
Search…
⌃K

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