I am trying to implement group by time(1h) and it’s working fine. Suppose for 2:00 o’clock I used group by method then it starts taking interval from 1:00 to 1:59 and 3:00 it starts from 2:00 to 2:59. Now I want to implement a method that takes both bound of the time. 1:00 and 2:00 for 2:00 timestamp and 3:00 take 2:00 and 3:00.
Can you try grouping by the equivalent minutes instead?
Also, may I ask what your end goal is? Why do you want to group by 1hr + 1min? and then overlap the grouping the next hour? Am I missing something?
Actually, I am getting data at 15 mins interval
So, I want to use group by for one hour including 01:00:00 and 02:00:00 timestamp and save under the timestamp 01:00:00.