This seems like a simple problem and I searched high and low through this community, trying various suggestions.
This query returns a dozen or so records (note that the times are in the future):
select * from alert where time > ‘2020-01-23T00:00:00Z’ and time < ‘2020-01-25T00:00:00Z’
This command returns no errors but does not delete the data:
delete from alert where time > ‘2020-01-23T00:00:00Z’ and time < ‘2020-01-25T00:00:00Z’
I also tried with tag = ‘value’ in the where clause. Same result.
I had originally executed the delete with time > now() + 1d and most of the records got deleted correctly, however there are about 50 records across 4 series that stubbornly refuse to go away.