Archives of the TeradataForum

Message Posted: Fri, 12 Apr 2013 @ 19:59:14 GMT

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

TIME '12:12:12' - TIME '00:00:00' HOUR TO SECOND computes the INTERVAL between two times of day.

The HOUR TO SECOND precision applies to the INTERVAL difference, not the TIME term being subtracted.

TIME '12:12:12' - INTERVAL '00:00:00' HOUR TO SECOND computes the TIME zero seconds before 12:12:12.

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