The time series graph display line with 1 hour delay compare to mysql data

[macrid]

Hello everybody.
First of, you have to know that my mother’s language is french. Please be kind with my mistakes…

You can see on the graph a jump @ 05h13. (Heater ON)

The data in mysql say 04h13

My rrd graph is OK, peak at 04h13.
The date on client and server are the same. belgium > CET
berni@server:~ $ date; date +%s
lun 30 déc 2024 11:43:37 CET
1735555417
berni@atelier:~$ date; date +%s
lun 30 déc 2024 11:43:38 CET
1735555418
The time display in grafana is set accordingly, browser time brussels CET UTC+01.
I have other graphs showing the same problem.
Do you need more informations ?
Thanks in advance and have a nice day.

Bernard

[ebabeshko]

Check if this topic helps:
https://community.grafana.com/t/time-series-shifted-one-hour-cet-vs-utc/

[macrid]

Thanks for your indication. I will surely NOT alter my databases, some are more than 10 years old. If you check my graph, left corner bottom. You will see conso last: 900 this is the good last value. Despite that, the graph is showing a value less than 800 ??? For me no problem I will not use anymore those time graphs and set my alarms on gauge graphs which are giving the good value. rrdtool work perfectly for me, I will so keep it. I also use jpgraph, a very powerfull php graphs generator.
Have a nice last day of the year.
Bernard

[macrid]

Hello everybody, I found a workaround, I added a second date_time field in the Db which contains UTC values and give it to grafana. Just a workaround, not happy with that. Give us a switch or config in grafana to use the data as there are without playing with…
Thanks for the help and Happy Newyear !!!

[yosiasz]

You could use a conver_tz kind of function to make grafana happy. Adding such a new column sounds like a maintenance nightmare

[macrid]

Hello yosiasz,

thanks a lot, YESSSSSS, it works !!!

CONVERT_TZ(date_time,‘+01:00’, ‘+00:00’)

[yosiasz]

But use proper time zone not numeric value

convert_tz(timestamp,‘US/Eastern’,‘UTC’)

@macrid