Hi,
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?
SELECT
TIMESTAMP AS “time”,
CAST(VALUE
AS FLOAT) AS “Telefon”
FROM history
WHERE
$__timeFilter(TIMESTAMP) AND
DEVICE
= “mqtt_mod_83_ch0” AND
READING
= “relay_0_power”
ORDER BY TIMESTAMP