I can’t get my data to display in the right time. I’m not sure why, but I get a 2hour gap in the start of the graph, while the data is available in MySql: [54] What also is very strange is that 2 graphs with exactly the same structure have different time offsets. As you can see the pressure graph…

Solved: [image] UTC to Local Time Zone Issue MySQL Data Source MySQL Alright so this is a little embarrassing, but it really shouldn’t be the solution. The server running MySQL and Grafana was set to PST time zone. Changing the system timezone to UTC solved all of the issu…

I have no idea what might be causing it. Sorry.

Sounds like one field is a DATETIME, and one is a TIMESTAMP. From mysql manual " MySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does not occur for other types such as DATETIME .)"

They are both DATETIME: [23] [02]

I a not sure what the original pictures are showing. Does the time shown in the popup match the timestamp on the axis?

The time on the X-axis represents the current time, but the datapoints are 2 hours ahead in the future, and are off the chart. [17] So the X-axis goed up to 15:00, the datapoints also go up to 15:00 in the database, but Grafana plots them 2 hours ahead, at 17:00 The datapoint that is in the toolt…

SOLVED! I’ve changed datetime to UNIX_TIMESTAMP(datetime) in the query, and everything is back to normal! Thanks everyone for trying to help me!

Did you have to do that on both of them?

Yes, I did it on both of them, and now everything is perfect!

CONVERT(VARCHAR(20), YourVariableName , 100) as time Please refer this for timeformats in mssql [image] Date and Time Conversions Using SQL Server There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a qu…

(SOLVED!) Time trouble (2 hours offset)

Grafana Time Series Panel

crockk February 4, 2021, 10:12pm 25

Solved:

Topic		Replies	Views
Timezone - only Graph makes troubles	13	1336	April 30, 2020
Grafana MariaDB / MySQL time issues Time Series Panel	5	1641	May 22, 2023
Data is delayed by 1 hour Time Series Panel	13	10501	February 6, 2025
Mysql datasource & timezone issue Grafana	12	6932	December 16, 2020
UTC to Local Time Zone Issue MySQL Data Source MySQL mysql	3	11774	February 4, 2021

(SOLVED!) Time trouble (2 hours offset)

Related topics