sql to delete rows from a table that are more than 3 days old.
Posted on 2008-02-08
I have a table with col1 - varchar2 and col2 - date columns
I want to remove those rows that are more 3 days old.
I don't want to use pl/sql code, I want to do it using sql
I tried using this statement but it failed:
delete from abc where to_date(dt) = to_date(sysdate)-3 ;
shows 0 rows deleted.