Archives of the TeradataForum
Message Posted: Tue, 14 Oct 2003 @ 11:58:44 GMT
In that case, use the INTERVAL data type.
Assume that column TS1 is defined as TimeStamp(0), and contains a date of 11th October 2003 (ignoring the time portion), the following will give a result of 15th October 2003 (ignoring the time portion).
TS1 + cast(4 as interval day)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|