I'm trying to store a timestamp in a variable and then compare it with time in influxdb
the code is:
msg.query = "SELECT time , Temper01 ,FROM ID WHERE time >= startdate AND time <= '2021-11-19T14:00:00Z' tz('America/Sao_Paulo') ";
Im getting startdate from a msg.payload and it comes in the correct timestamp format but i keep getting this error message:
"Error: Error from InfluxDB: invalid operation: time and *influxql.VarRef are not compatible"