Archives of the TeradataForum

Message Posted: Fri, 21 May 2004 @ 20:01:49 GMT

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

<-- Anonymously Posted: Friday, May 21, 2004 15:55 -->

Try increasing the expiration date by 10 years using -

     case
        when EXPIRATION_DATE < CURRENT_DATE
              then EXPIRATION_DATE + 3650
        else EXPIRATION_DATE
        end as NEW_DATE

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