Archives of the TeradataForum

Message Posted: Thu, 17 Jun 2004 @ 20:54:59 GMT

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

I need to code a SQL select which determines how many minutes between two timestamp(0) columns and cast this number as a Decimal(9,0) for subsequent calculations. The timestamps could be as much as 20 years apart. I tied using intervals but, since the largest interval value seems to be 9999, overflow occurred. Any suggestions?

Thanks

Dave

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