Query with now-1h singlestat

1

Hi,

I have an Singlestat panel that show the current( is the last from db) temperature.
With my query
SELECT last("value") FROM "Vriezer_115_temperatuur" WHERE time > 0 ORDER BY time DESC LIMIT 1

This works perfect, however I want only if the value is from the last hour for example and not older
SELECT last("value") FROM "Vriezer_115_temperatuur" WHERE time > now-1h ORDER BY time DESC LIMIT 1
Unfortunately this not works, what do I miss?

Influxdb with Grafana 6.3.2

2

To answer my own question.

SELECT last("value") FROM "Vriezer_115_temperatuur" WHERE time > now()-1h ORDER BY time DESC LIMIT 1