Timezone issue in MS SQL

Grafana MSSQL
1

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

    Version 10.2.3

  • What are you trying to achieve?

    I am trying to get sum based on time series for the current month

  • How are you trying to achieve it?

    Through simple queries using MS SQL as data source

  • What happened?
    Whenever i choose a time-series it converts query into UTC i am in UTC +5

Screenshot from 2024-01-08 19-58-43
Screenshot from 2024-01-08 19-58-43958×873 145 KB

Check screenshot line no 4 and time is starting from 01-01-2024

I have set the timezone in grafana.ini and also in configuration but nothing has worked for me so far.
In MySQL connection i have a field called session timezone but not in MS SQL

2

It is correct that your query gets converted into UTC, because that is what
should exist in the data source you are querying.

If you have timestamps in your data source which are not in UTC, then you will
get problems, for example on the day when there are two occurrences of 02:30.

Antony.

1 Like