Apache Pinot Docs
Search…
latest
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

1
select dayOfYear(1639351800000) AS dayOfYear
2
FROM ignoreMe
Copied!
dayOfYear
346
1
select dayOfYear(1639351800000, 'CET') AS dayOfYear
2
FROM ignoreMe
Copied!
dayOfYear
347
1
select doy(1639351800000) AS dayOfYear
2
FROM ignoreMe
Copied!
dayOfYear
346
1
select doy(1639351800000, 'CET') AS dayOfYear
2
FROM ignoreMe
Copied!
dayOfYear
347
Last modified 1mo ago
Copy link