◀ Back to Playground Home

Convert timestamp (epoch millis) to days since epoch bucketed at 1 day granularity

SELECT timestamp_field,
       DATETIMECONVERT(
         timestamp_field, 
         '1:MILLISECONDS:EPOCH', 
         '1:DAYS:EPOCH', 
         '1:DAYS'
       ) AS convertedTime
FROM users