Archives of the TeradataForum

Message Posted: Mon, 18 Aug 2008 @ 13:11:56 GMT

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

Hi,

Try this,

     Select Current_timestamp(0) - INTERVAL '30 00:00' DAY TO MINUTE;
     Result: 2008-07-19 08:04:58+00:00

     Select Current_timestamp(0);
     Result: 2008-08-18 08:04:01+00:00

Best Regards,

Kapil D Sapra

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