What Grafana version and what operating system are you using?
What are you trying to achieve?
Pulling the correct datetime value
How are you trying to achieve it?
Converting my datetime field to the format “MM-dd-yyyy hh tt”
After converting my datetime field to the time field so I can view it on a graph, it actually shows 04:00:00 instead of 09:00:00. The queries are the exact same when run in SSMS and in Grafana.
What did you expect to happen?
for it to show “09/14/2021 9:00:00” instead of “09/14/2021 04:00:00”
Can you copy/paste the configuration(s) that you are having problems with?
Here is the query for getting the datetime format run in both SSMS and in Grafana:
CONVERT(DATETIME, FORMAT(CONVERT(DATETIME, WashDate, 102), 'MM/dd/yyyy HH tt'), 102) as 'time'
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
Did you follow any online instructions? If so, what is the URL?
I found no results online.
I fixed it. I needed to change my timezone if anyone was wondering.