Comment on page
day
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 |
Last modified 1yr ago