Powered by GitBook

1 of 1

Loading...

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

dayOfYear

dayOfYear

dayOfYear

dayOfYear

select dayOfYear(1639351800000) AS dayOfYear
FROM ignoreMe

346

347

346

347

select dayOfYear(1639351800000, 'CET') AS dayOfYear
FROM ignoreMe

select doy(1639351800000) AS dayOfYear
FROM ignoreMe

select doy(1639351800000, 'CET') AS dayOfYear
FROM ignoreMe