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
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 |
Last modified 1yr ago