Archives of the TeradataForum

Message Posted: Tue, 25 May 2004 @ 15:19:46 GMT

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

ANSI standard says MONTH / YEAR interval arithmetic should not adjust day of month. Teradata implemented the ADD_MONTHS() extension specifically to address this problem:

     SELECT ADD_MONTHS(date '2004-02-29', -12)
       2003-02-28

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