at my mariaDB I have got the right timestamp. At Grafana I have put the time zone to ‘Browser Time’.
But if I fetch data from mariaDB Grafana keeps adding 2 hours of time to it. mariaDB timestamp: 6:02, fetch table data of grafana: 8:02. Obvious its the time diffrence between UTC and local time (+2h).
I tried a lot. But could not manage to get it right. So, why is it pls?
TIMESTAMP AS “time”,
VALUE AS FLOAT) AS “Telefon”
DEVICE = “mqtt_mod_83_ch0” AND
READING = “relay_0_power”
ORDER BY TIMESTAMP