fromepochbucket.md

description
This section contains reference documentation for the fromEpochBucket functions.

FromEpochBucket

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

Signature

FromEpoch<TIME_UNIT>Bucket(timeInMillis, bucketSize)

Usage Examples

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