Comment on page
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.
dayOfYear(tsInMillis)dayOfYear(tsInMillis, timeZoneId)doy(tsInMillis)doy(tsInMillis, timeZoneId)
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