Apache Pinot Docs
Search…
latest
FromEpoch
This section contains reference documentation for the fromEpoch functions.
Convert epoch to epoch milliseconds. The following time units are supported:
  • SECONDS
  • MINUTES
  • HOURS
  • DAYS

Signature

FromEpoch<TIME_UNIT>(timeIn<Time_UNIT>)

Usage Examples

1
select FromEpochSeconds(1613472303) AS epochMillis
2
FROM ignoreMe
Copied!
epochMillis
1613472303000
1
select FromEpochMinutes(26891205) AS epochMillis
2
FROM ignoreMe
Copied!
epochMillis
1613472300000
1
select FromEpochHours(448186) AS epochMillis
2
FROM ignoreMe
Copied!
epochMillis
1613469600000
1
select FromEpochDays(18674) AS epochMillis
2
FROM ignoreMe
Copied!
epochMillis
1613433600000
Last modified 1mo ago
Copy link