I use Grafana v9.3.2 on a Windows 2016 Server. The server shows correct time in taskbar (timezone Europe/Berlin). A mysql server is running there as well.
If I run following query on the mysql server, it shows correct time:
Grafana is set to:
If I run the same query in grafana it shows:
It is one hour ahead - why please?
What timezone are you in? utc+1?
Because grafana works with UTC, it expects/assumes all datetime columns are utc
@yosiasz: Thanks, does that mean I have to change my SQL query to subtract 1 hour from the result? Or is there any setting in Grafana to compensate that?
Look for functions that convert your datetime column to utc on the fly,dynamically such as following
SELECT Read_date AT TIME ZONE 'UTC'