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