description
This section contains reference documentation for the toEpochRounded functions.

ToEpochRounded

Convert epoch milliseconds to epoch , round to nearest rounding bucket(Bucket size is defined in ) The following time units are supported:

Signature

ToEpoch<TIME_UNIT>Rounded(timeInMillis, bucketSize)

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