Archives of the TeradataForum

Message Posted: Tue, 06 Jan 2004 @ 21:47:20 GMT

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

Timestamp difference is of INTERVAL data type, so you just need to specify the interval format required.

Examples:

SELECT (END_TIME - START_TIME) DAY(4) TO SECOND from table_a;

SELECT (END_TIME - START_TIME) DAY(2) TO HOUR from table_a;

SELECT (END_TIME - START_TIME) YEAR(2) TO MONTH from table_a;

etc.

Check out "SQL Reference Vol. 3" for more information.

Regards,

Victor

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