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