Datetime Showing Different Than SSMS

Grafana
1

  • What Grafana version and what operating system are you using?
    8.0.0

  • 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”

  • What happened?
    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.
    image

    image
    image626×503 28.2 KB

  • 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.
    No

  • Did you follow any online instructions? If so, what is the URL?
    I found no results online.

2

I fixed it. I needed to change my timezone if anyone was wondering.

1 Like
3

This topic was automatically closed after 365 days. New replies are no longer allowed.