Archives of the TeradataForum

Message Posted: Tue, 09 Mar 2010 @ 15:49:47 GMT

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

For the hour and second precision

     select cast(cast (155  as interval hour(4)) as interval day(4) to second(6))

Regards.

Patrick

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