select userId, startTime, HOUR(startTime) AS starthour FROM usersession WHERE userId IS NOT NULL and startTime between "2019-07-02 00:00:00" and "2019-07-02 06:00:00"
userId startTime starthour
**** July 2, 2019 - 07:19 03 h
So, for some reason 07 in the morning is translated to 03h and is in the range of between 0:00 and 06:00
Is there an explanation for this?
I'm not able to reproduce this. We are extracting the local timezone from the browser and the result should be based on this. I would suggest to open a support ticket with as much details as possible such as the environment, browser and browser version etc.