Re: Downsampliing data, but define interval start time?

[Peter Brawley]

Your first interval starts on the computed starting hour, but your Where clause limits data to >= 00:30; The problem is just labelling, isn't it? In which case you can solve it with an outer query that relabels that first bin.

BTW wouldn't FLOOR( HOUR(datetime) / 2 ) more simply give you 2-hr periods you could then label as you please?



Edited 1 time(s). Last edit at 05/04/2022 11:56AM by Peter Brawley.