| description |
|---|
This section contains reference documentation for the day function. |
Returns the day of the month from the given epoch millis in UTC or specified timezone. The value ranges from 1 to 31.
day(tsInMillis)
day(tsInMillis, timeZoneId)
dayOfMonth(tsInMillis)
dayOfMonth(tsInMillis, timeZoneId)
select day(1639351800000) AS day
FROM ignoreMe| day |
|---|
| 12 |
select day(1639351800000, 'CET') AS day
FROM ignoreMe| day |
|---|
| 13 |
select dayOfMonth(1639351800000) AS day
FROM ignoreMe| day |
|---|
| 12 |
select dayOfMonth(1639351800000, 'CET') AS day
FROM ignoreMe| day |
|---|
| 13 |