Firstly, Merry Christmas all!
Now, I’m trying to query my database from the command line to return results from the last hour.
I’m using InfluxDB 1.8.3 on a Raspberry Pi running dietPi.
The command I’m running is either
influx -precision rfc3339 -format csv -database airpressure -execute “SELECT “bathroomhumid” FROM “airpressure” WHERE time > now() - 1h”
Or from influx run interactive:
SELECT “bathroomhumid” FROM “airpressure” WHERE time > now() - 1h
But no results are being returned. What am I doing wrong? There is definitely data under that measurement, but even trying - 24h doesn’t show it.