# How to delete items using a timestamp?

**URL:** https://community.questdb.com/t/how-to-delete-items-using-a-timestamp/132
**Category:** Community
**Tags:** question
**Created:** [August 2, 2024, 4:12pm UTC](https://community.questdb.com/t/how-to-delete-items-using-a-timestamp/132 "2024-08-02T16:12:44Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex004/uploads/questdb/original/1X/b6b1b349e598d0550947e63d7923a9d7df0279eb.png) [@system](https://community.questdb.com/u/system)
#### Post date: [August 2, 2024, 4:12pm UTC](https://community.questdb.com/t/how-to-delete-items-using-a-timestamp/132/1 "2024-08-02T16:12:44Z")

</div>

Hi!

Can I delete items using a timestamp?

Also is it possible to delete a specific item? eg id=1

---

<div class="post-metadata">

### Author: ![nwoolmer](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.questdb.com/nwoolmer/32/24_2.png) [@nwoolmer](https://community.questdb.com/u/nwoolmer)
#### Post date: [August 2, 2024, 4:14pm UTC](https://community.questdb.com/t/how-to-delete-items-using-a-timestamp/132/2 "2024-08-02T16:14:00Z")

</div>

There is no row level delete.

You can work round this using an extra column with a deleted flag, and set it with dedup inserts or UPDATE. Then, filter out these ‘deleted’ rows

Otherwise, you must drop partitions.