# InfluxDB | Delete measurement information between to times
**URL:** https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010
**Category:** General
**Created:** [29 January 2021 18:33 UTC](https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010 "2021-01-29T18:33:27Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@vikozo](https://discourse.nodered.org/u/vikozo)
#### Post date: [29 January 2021 18:33 UTC](https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010/1 "2021-01-29T18:33:27Z")
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
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [29 January 2021 20:33 UTC](https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010/2 "2021-01-29T20:33:36Z")
The influx docs are quite good. See [Manage your database using InfluxQL | InfluxDB OSS 1.8 Documentation](https://docs.influxdata.com/influxdb/v1.8/query_language/manage-database/#delete-series-with-delete)
---
### Author:  [@vikozo](https://discourse.nodered.org/u/vikozo)
#### Post date: [29 January 2021 21:39 UTC](https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010/3 "2021-01-29T21:39:11Z")
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 😉
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [29 January 2021 21:59 UTC](https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010/4 "2021-01-29T21:59:08Z")
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.
---
### Author:  [@vikozo](https://discourse.nodered.org/u/vikozo)
#### Post date: [29 January 2021 22:03 UTC](https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010/5 "2021-01-29T22:03:51Z")
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'
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [12 February 2021 22:04 UTC](https://discourse.nodered.org/t/influxdb-delete-measurement-information-between-to-times/40010/6 "2021-02-12T22:04:30Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.