Delete measurement information between to times


I need to delet some datas in a measurement

I know the measurement is in Egolzwil

need to delete all
information in Egolzwil
from the 2021-01-28 23:36:30 till 2021-01-29 16:56:30

how to do this correct way?

have a nice day

Please tell us which version of InfluxDB you are using.



Connected to http://localhost:8086 version 1.8.3
InfluxDB shell version: 1.8.3

Hoi vinc

Du kannst das in dieser Art lösen, hat bei mir funktioniert (auch V1.8.3) …

DELETE from “mqtt_consumer” where time > ‘2021-02-01T11:36:12.299974334Z’ AND time < ‘2021-02-01T11:40:42.262688206Z’

→ measurement hier “mqtt_consumer”

Gruss aus Oberkirch

Vielen Dank Thanks for your help