◀ Back to Playground Home

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

select timestamp_field, 
       CAST(timestamp_field as long), 
       ToEpochSecondsRounded(timestamp_field, 500),
    ToEpochSecondsRounded(timestamp_field, 1000)
from users