Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Timestamp - Timestamp: Invalid expression for ANSI datetime
 
From:   Victor Sokovin

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016