Timezone issue in MS SQL

  • 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

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

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.


1 Like