Archives of the TeradataForum

Message Posted: Wed, 15 Mar 2006 @ 17:58:32 GMT

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

This should work -

     select (cast(ts1 as date) - cast(ts2 as date)) * 1440
                  + cast(((ts1 - ts2)  minute(4)) as int)

Wayne Schachtel
Wayne Schachtel Consulting

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