cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

hour starttime in USQL gives strange results

Bert_VanderHeyd
Advisor

USQL:

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"

gives:

userId startTime starthour

**** July 2, 2019 - 07:10 03 h

**** 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?


4 REPLIES 4

Only Idea I have is that Dynatrace is storing data in GMT time zone. What is yours? If your is +4h than 3 am should change on GUI level to 7am. But there may be issue here with USQl

Sebastian


I thought about it, but we are at +1, so the math doesn't make sense


So I suggest support ticket.


christian_gusta
Dynatrace Helper
Dynatrace Helper

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.