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

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 updated