Archives of the TeradataForum
Message Posted: Thu, 13 Dec 2012 @ 20:00:12 GMT
I have a requirement to keep only 4 weeks of data in target table based on a date column in the table.
2-Dec, 9-Dec, ?, 23-Dec
I tried to delete the data based on System date - 28 but this condition fails if there is no run for previous week. I.e. There will be data for three weeks instead of four.
Is it possible to get the date from the table and compare with sysdate and delete the data which is more than four week?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|