Grafana is 1 hour ahead

Grafana MySQL
1

Hi,

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:
Grafana1_TimeAhead1

Grafana is set to:
Grafana1_TimeAhead0

If I run the same query in grafana it shows:
Grafana1_TimeAhead2

It is one hour ahead - why please?

2

What timezone are you in? utc+1?

3

Yes -Germany is UTC + 1

4

Because grafana works with UTC, it expects/assumes all datetime columns are utc

1 Like
5

@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?

6

Look for functions that convert your datetime column to utc on the fly,dynamically such as following

SELECT Read_date AT TIME ZONE 'UTC'