Archives of the TeradataForum

Message Posted: Tue, 28 Aug 2007 @ 13:51:32 GMT

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

Hello,

You may cast col1 to an interval in second like this :

     select current_timestamp(0) + cast( test.col1 as interval second)
     from (select '1' as col1) test

Be carreful , if col1 has values greater than 9999 you will have to convert it into hours and seconds

Good luck

Christophe

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