Powered by GitBook

1 of 1

Loading...

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

Signature

FromEpoch<TIME_UNIT>Bucket(timeInMillis, bucketSize)

Usage Examples

bucket

bucket

bucket

bucket

bucket

1613472303000

3226944606000

1613472000000

1613466000000

1613088000000

select FromEpochSecondsBucket(1613472303, 1) AS bucket
FROM ignoreMe

select FromEpochSecondsBucket(1613472303, 2) AS bucket
FROM ignoreMe

select FromEpochMinutesBucket(2689120, 10) AS bucket
FROM ignoreMe

select FromEpochHoursBucket(89637, 5) AS bucket
FROM ignoreMe

select FromEpochDaysBucket(1867, 10) AS bucket
FROM ignoreMe