Archives of the TeradataForum

Message Posted: Mon, 06 Jun 2005 @ 09:46:59 GMT

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

I need to delete data over 36 months old, determined by a column defined as Char(6)'YYYYMM' . I've tried various ways without success but does anybody know if it is possible to cast the char(6) as date and use Add_Months to identify rows to delete ?

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