Archives of the TeradataForum
Message Posted: Mon, 06 Jun 2005 @ 09:46:59 GMT
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|