Apache Pinot Docs
latest
Search
⌃K

week

This section contains reference documentation for the week function.
Returns the ISO week of the year from the given epoch millis in UTC or specified timezone. The value ranges from 1 to 53.

Signature

week(tsInMillis)
week(tsInMillis, timeZoneId)
weekOfYear(tsInMillis)
weekOfYear(tsInMillis, timeZoneId)

Usage Examples

select week(1639351800000) AS week
FROM ignoreMe
week
49
select week(1639351800000, 'CET') AS week
FROM ignoreMe
week
50
select weekOfYear(1639351800000) AS week
FROM ignoreMe
week
49
select weekOfYear(1639351800000, 'CET') AS week
FROM ignoreMe
week
50
Last modified 1yr ago