1 of 1

second

This section contains reference documentation for the second function.

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

Signature

second(tsInMillis)
second(tsInMillis, timeZoneId)

select second(1639351800000) AS second
FROM ignoreMe

second

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

second

This section contains reference documentation for the second function.

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

second(tsInMillis)
second(tsInMillis, timeZoneId)

select second(1639351800000) AS second
FROM ignoreMe

second

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

second