Archives of the TeradataForum
Message Posted: Tue, 06 Jan 2004 @ 20:14:46 GMT
<-- Anonymously Posted: Tuesday, January 06, 2004 13:50 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|