Apache Pinot Docs
Search…
latest
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)

Usage Examples

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