Apache Pinot Docs
latest
Search…
⌃K

dayOfYear

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

Signature

dayOfYear(tsInMillis)
dayOfYear(tsInMillis, timeZoneId)
doy(tsInMillis)
doy(tsInMillis, timeZoneId)

Usage Examples

select dayOfYear(1639351800000) AS dayOfYear
FROM ignoreMe
dayOfYear
346
select dayOfYear(1639351800000, 'CET') AS dayOfYear
FROM ignoreMe
dayOfYear
347
select doy(1639351800000) AS dayOfYear
FROM ignoreMe
dayOfYear
346
select doy(1639351800000, 'CET') AS dayOfYear
FROM ignoreMe
dayOfYear
347
Last modified 1yr ago