Data for a particular minute


I have a time series data that is stored by minutely time stamp e.g. YYYY-MM-DD-HH:MM:00.

I want to query data generated for a given minute for all days. I tried something like "
select * from measurement where time = ‘09:45:00’

This doesn’t work, and I got the following error:
ERR: invalid operation time and *influxql.stringLiteral are not compatible

Any insight on the error will be helpful.


1 Like

i have the same error here
how did you resolve it