'delete data only between may 6 and may 18, 2022
I have a table with CLIENT_CONTACT data, where there is call data from 2020 to today.
How can I delete data only between May 6 and May 18, 2022, did I write correctly?
DELETE FROM CLIENT_CONTACT
WHERE rep_date >= TO_DATE('06.05.2022', 'dd.mm.yyyy') AND rep_date <= TO_DATE('18.05.2022', 'dd.mm.yyyy')
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
