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
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