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

PreviousdayOfWeekNextDISTINCT