Archives of the TeradataForum

Message Posted: Mon, 18 Aug 2008 @ 13:20:46 GMT

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

Try using the "interval" syntax:

     Select Current_timestamp(0) - interval '30' day as prunedate
        From (Select 1) Tmp (ONE);

Kevin R Tewksbury
Sr. Database Administrator
LimitedBrands
Limited Technology Services

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