Archives of the TeradataForum

Message Posted: Tue, 23 Oct 2012 @ 08:41:46 GMT

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

You can easily convert number of seconds to an INTERVAL:

     NumOfSecs*INTERVAL '00:00:01.00' HOUR TO SECOND(2)

Note that when dealing with TIME fields, you have to think about time zone and daylight saving adjustments.

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