◀ Back to Playground Home

Convert timestamp (epoch millis) to epoch minutes, rounded to a bucket

select timestamp_field, 
       CAST(timestamp_field as long), 
       ToEpochMinutesRounded(timestamp_field, 10),
       ToEpochMinutesRounded(timestamp_field, 30)
from users