MySQL timeseries data not displayed correctly

[ekjotsingh]

Timeseries data from MySQL database is having different values in grafana. I have attached the grafana dashboard, MySQL table schema and the table content.

Thanks in advance for any help.

[yosiasz]

Check the last comment here, it might help

Grafana not handling timezone correct for MariaDB

I am able to plot it using following function in sql server SELECT DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), measurementtime) as time, celsius as value, sensorpurpose as metric FROM temperatures ORDER BY measurementtime ASC [image]