Qianbo Wang
09/16/2021, 11:43 PMDATETIMECONVERT . It mentions it buckets the time based on the given time granularity, but what is the start of the first bucket? e.g. when running this query:
SELECT DATETIMECONVERT(time_col, '1:MILLISECONDS:EPOCH', '1:SECONDS:EPOCH', '30:DAYS') as new_time_col, COUNT(id) FROM table WHERE (time_col BETWEEN <epoch_second of 7/16> AND <epoch_second of 9/16>) AND GROUP BY new_time_col ORDER BY new_time_col
It returns 3 buckets for: 7/1, 7/31 and 8/30. So I wonder how is this being calculated?Qianbo Wang
09/16/2021, 11:44 PMQianbo Wang
09/16/2021, 11:45 PMDATETIMECONVERT(time_col, '1:MILLISECONDS:EPOCH', '1:SECONDS:EPOCH', '720:HOURS')Jackie
09/16/2021, 11:48 PMQianbo Wang
09/17/2021, 12:02 AMQianbo Wang
09/17/2021, 5:56 PM