I create a sample measurement and store current UTC in a field called “eventTime”. Now I want to use now() filter on that field. But now() filter is working only on time field. Could you guide us how to fix this problem? I am using Influxdb V 1.8.3
Here is outcome of influxdb:
SHOW FIELD KEYS FROM sample
eventId float
eventTime integer
port stringSELECT * FROM sample
time | eventId | eventTime | port
1616667805972021575 | 2 | 1616667623628931629 | 25
1616667872553914924 | 3 | 1616667805972021575 | 80
select * from sample where eventTime < now()