Apache Pinot Docs
latest
Ask or search…
K
Comment on page

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

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