minute

This section contains reference documentation for the minute function.

Returns the minute of the hour from the given epoch millis in UTC or specified timezone. The value ranges from 0 to 59.

Signature

minute(tsInMillis)

minute(tsInMillis, timeZoneId)

Usage Examples

select minute(1639351800000) AS minute
FROM ignoreMe

minute
30

select minute(1639351800000, 'America/St_Johns') AS minute
FROM ignoreMe

minute
0