Archives of the TeradataForum

Message Posted: Tue, 06 Jan 2004 @ 20:14:46 GMT

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

<-- Anonymously Posted: Tuesday, January 06, 2004 13:50 -->

Hi,

When I the execute the following query, I get an error "invalid expression for ANSI datetime". Can someone please explain why it does so and how to get the difference between two timestamp columns ?

SELECT (END_TIME - START_TIME) from table_a;

where END_TIME and START_TIME are defined as TIMESTAMPS.

Thanks,

Padhu..

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