InfluxDB | Delete measurement information between to times

General
1

Hello

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
vinc

InfluxDB shell version: 1.8.3

2

The influx docs are quite good. See Manage your database using InfluxQL | InfluxDB OSS 1.8 Documentation

3

go to the Database and do a

DELETE FROM "Egolzwil" WHERE time > '2021-01-28T23:00:00Z'

but did not find out how to cut between to date/time
and because it did work have no option to test it again :wink:

4

I imagine you wanted
DELETE FROM "Egolzwil" WHERE time > '2021-01-28T23:00:00Z' and time <= ....

Whenever you are about to do a DELETE you can first try it with SELECT * FROM ... to check which records it will delete.

5

yes it works like you wrote it.
Merci @Colin
DELETE FROM "Egolzwil" WHERE time > '2021-01-27T22:55:00Z' and time <= '2021-01-28T23:00:00Z'

6

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.