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

1 Like