Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 20:40:09 GMT

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

To get the difference in minutes, Try:

(EXTRACT(DAY FROM ((a_ts - b_ts) DAY(4) TO MINUTE))*1440 +
EXTRACT(HOUR FROM ((a_ts - b_ts) DAY(4) TO MINUTE))*60 +
EXTRACT(MINUTE FROM ((a_ts - b_ts) DAY(4) TO MINUTE)))

Thanks

Kranti Penmethsa
IT - DSS, Norfolk Southern

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