Comment on page

month

This section contains reference documentation for the month function.

Returns the month of the year from the given epoch millis in UTC or specified timezone. The value ranges from 1 to 12.
Signature
month(tsInMillis)
month(tsInMillis, timeZoneId)
Usage Examples
select month(1633046399000, 'UTC') AS month
FROM ignoreMe
month
9
select month(1633046399000, 'CET') AS month
FROM ignoreMe
month
10

month
9

month
10

mode

mult

Last modified 1yr ago