I am looking for a solution that will delete bunch of tables if the date is greated than a column in the table 60 days
DELETE FROM TABLE_A WHERE CAST(LOAD_DS AS DATE) < NOW() - INTERVAL 60 DAY;
Here LOAD_DS is a column name in table_A when the data was inserted in the table_A
Solved! Go to Solution.