Apache Pinot Docs
Search…
latest
millisecond
This section contains reference documentation for the millisecond function.
Returns the millisecond of the second from the given epoch millis in UTC or specified timezone. The value ranges from 0 to 999.

Signature

millisecond(tsInMillis)
millisecond(tsInMillis, timeZoneId)

Usage Examples

1
select millisecond(1639351800000) AS millisecond
2
FROM ignoreMe
Copied!
millisecond
0
1
select millisecond(1639351800000, 'America/St_Johns') AS millisecond
2
FROM ignoreMe
Copied!
millisecond
0
Last modified 1mo ago
Copy link