Archives of the TeradataForum

Message Posted: Tue, 28 Aug 2007 @ 13:58:06 GMT

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

<-- Anonymously Posted: Tuesday, August 28, 2007 07:21 -->

Hi Suhail,

try this:

     select
      current_timestamp(0)
     ,col1
     ,current_timestamp(0) + cast(col1 as interval SECOND )
     from test

This should work for your problem.

Best wishes

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