Archives of the TeradataForum
Message Posted: Mon, 24 May 2004 @ 13:22:59 GMT
| Subj: | | Re: How can I advance a date value? |
| |
| From: | | Geoffrey Rommel |
| | Try increasing the expiration date by 10 years using - | |
case
when EXPIRATION_DATE < CURRENT_DATE
then EXPIRATION_DATE + 3650
You probably realized this just after sending the note, but this will not give the desired results. For instance:
expiration_date (expiration_date+3650)
2004-02-25 2014-02-22 /* Off by 3 days */
2004-03-01 2014-02-27 /* Off by 2 days */
| 
