CODEWITHSUNDEEP
sqloracle-databasedatesql-delete
Marcus
Marcus

Reputation: 3869

How to delete data older than particular month specified in oracle sql

I want to delete data for older than September month of this year. Previously i was trying to delete data for older than 24 hours for which query is mentioned below and its working fine. The TIMESTAMP column has data type date.

Delete FROM ALERT_LOGS WHERE TIMESTAMP > SYSDATE - 1 ;

Upvotes: 0

Views: 1458

Answers (1)

Mindaugas Tamosevicius
Mindaugas Tamosevicius

Reputation: 172

Delete FROM ALERT_LOGS WHERE TIMESTAMP < DATE '2015-09-01' ;

Upvotes: 2

Related Questions