Apache Pinot Docs
latest
Search…
⌃K

ToEpochRounded

This section contains reference documentation for the toEpochRounded functions.
Convert epoch milliseconds to epoch , round to nearest rounding bucket(Bucket size is defined in ) The following time units are supported:
  • SECONDS
  • MINUTES
  • HOURS
  • DAYS

Signature

ToEpoch<TIME_UNIT>Rounded(timeInMillis, bucketSize)

Usage Examples

select ToEpochSecondsRounded(1613472303000, 1000) AS epochSeconds
FROM ignoreMe
epochSeconds
1613472000
select ToEpochMinutesRounded(1613472303000, 10) AS epochMins
FROM ignoreMe
epochMins
26891200
select ToEpochHoursRounded(1613472303000, 5) AS epochHours
FROM ignoreMe
epochHours
448185
select ToEpochDaysRounded(1613472303000, 10) AS epochDays
FROM ignoreMe
epochDays
18670