Help with influxdb query syntax

Third party integrations Node-RED
1

Hi all.

I am using a influxdb node to write data to thwe database and works quiet well. However I would like to query the database to get a value that was written 24 hours ago.

Looking at the node it looks possible but can someone help me with the syntax please

Peter

2

Ok getting there. I am trying to compare the dark sky predictions/forecast with current rain etc.

So I have worked out so far to use as my query
SELECT value FROM "mm/h" WHERE entity_id='dark_sky_precip_intensity_18h' limit 1

and I get a value for the forecast that is an 18h ahead. So how can I get that value but from 18 hours ago?