Apache Pinot Docs
Search…
latest
Configuration Reference
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
Copy link