Archives of the TeradataForum

Message Posted: Wed, 03 Sep 2003 @ 15:13:15 GMT

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

Much simplier expression for what you are doing. Check into ANSIINTERVAL

select avg((cast(timestampfield as time) - time '00:00:00.000000') hour to second) from table

Brad

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