FromEpochBucket
This section contains reference documentation for the fromEpochBucket functions.
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
bucket |
|---|
1613472303000 |
select FromEpochSecondsBucket(1613472303, 2) AS bucket
FROM ignoreMe
bucket |
|---|
3226944606000 |
select FromEpochMinutesBucket(2689120, 10) AS bucket
FROM ignoreMe
bucket |
|---|
1613472000000 |
select FromEpochHoursBucket(89637, 5) AS bucket
FROM ignoreMe
bucket |
|---|
1613466000000 |
select FromEpochDaysBucket(1867, 10) AS bucket
FROM ignoreMe
bucket |
|---|
1613088000000 |
Last modified 1yr ago