Powered by GitBook

1 of 1

Loading...

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.

Signature

day(tsInMillis)
day(tsInMillis, timeZoneId)
dayOfMonth(tsInMillis)
dayOfMonth(tsInMillis, timeZoneId)

Usage Examples

day

day

day

day

select day(1639351800000) AS day
FROM ignoreMe

12

13

12

13

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

select dayOfMonth(1639351800000) AS day
FROM ignoreMe

select dayOfMonth(1639351800000, 'CET') AS day
FROM ignoreMe