This section contains reference documentation for the millisecond function.
Last updated 2 years ago
Returns the millisecond of the second from the given epoch millis in UTC or specified timezone. The value ranges from 0 to 999.
millisecond(tsInMillis)millisecond(tsInMillis, timeZoneId)
millisecond(tsInMillis)
millisecond(tsInMillis, timeZoneId)
select millisecond(1639351800000) AS millisecond FROM ignoreMe
select millisecond(1639351800000, 'America/St_Johns') AS millisecond FROM ignoreMe
0