Archives of the TeradataForum

Message Posted: Fri, 25 Jan 2002 @ 17:20:46 GMT

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

You need to use the INTERVAL variables.

Here is an example on getting difference in HOURS

(CURRENT_TIMESTAMP(0) - rqst_time) HOUR(2)

rqst_time is TIMESTAMP(0)

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