◀ Back to Playground Home

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

select timestamp_field, 
       CAST(timestamp_field as long), 
       ToEpochHoursRounded(timestamp_field, 5),
       ToEpochHoursRounded(timestamp_field, 10)
from users