Archives of the TeradataForum

Message Posted: Mon, 13 Oct 2003 @ 12:38:51 GMT

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

Nancy,

You don't need a special function in Teradata, simply add the required number of days to a DATE column.

If TXN_DT is defined as DATE data type and contains 31st Jan, coding:

TXN_DT + 2 results in 2nd Feb.

Cheers,

Dave

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