Archives of the TeradataForum

Message Posted: Thu, 13 Dec 2012 @ 20:00:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Experts,

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?

Please assist!!

Regards,

John

	<Prev	Next>		<<First	<Prev	Next>	Last>>