Last updated 3 years ago
Was this helpful?
Convert epoch to epoch milliseconds. e.g. 10 seconds since epoch or 5 minutes since Epoch. The following time units are supported:
SECONDS
MINUTES
HOURS
DAYS
FromEpoch<TIME_UNIT>Bucket(timeInMillis, bucketSize)
select FromEpochSecondsBucket(1613472303, 1) AS bucket FROM ignoreMe
1613472303000
select FromEpochSecondsBucket(1613472303, 2) AS bucket FROM ignoreMe
3226944606000
select FromEpochMinutesBucket(2689120, 10) AS bucket FROM ignoreMe
1613472000000
select FromEpochHoursBucket(89637, 5) AS bucket FROM ignoreMe
1613466000000
select FromEpochDaysBucket(1867, 10) AS bucket FROM ignoreMe
1613088000000
This section contains reference documentation for the fromEpochBucket functions.