Archives of the TeradataForum

Message Posted: Mon, 13 Oct 2003 @ 19:16:10 GMT

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

Try using intervals.

SEL CURRENT_DATE + INTERVAL '30' DAY;
--> 2003-11-12

SEL CURRENT_TIMESTAMP + INTERVAL '30' MINUTE;
--> 2003-10-13 15:07:31.81

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