◀ Back to Playground Home

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

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