Hello, I am a new user to Grafana and have been using it for over a month now. I have an issue with the time zone when I am trying to download the CSV file from the Data tab in Query Inspector.
I am using MSSQL Server as the Data Source and below is the format in which the Date and Time are saved inside the database.
I want the same date and time format when I try to export the CSV file as well.
Here I have chosen the present day for the time range, the graph is displayed correctly.
But as you can see, the data is not the same when I try to export the CSV. +7 hrs has been added to the time.
I know it has something to do with the timezone format, I live in Bangkok which follows the :Asia/Bangkok UTC+07:00 timezone. I want my data to be exported in the above format not with +7 hrs added.
How do I do this? Any help would be much appreciated. Thanks!