Retrive sessions between hours interval

Hi sc_chatbot!

Yes, that is correct, the times in Inquire are displayed as UTC and you will need to use the timezone parameter to change it, just like you did above.

Edit: adding an example query here:

la s.id , hour, t.e1.userInput as userInput: 
  catd(pattern="HH", timezone="+02:00") s.beginTime as hour,  
  hour == in {"01".."20"}                  
  order by hour

Warm regards,