Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 May 2005 @ 12:15:19 GMT


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


Subj:   Re: Calculate TIMESTAMP difference
 
From:   Victor Sokovin

  As you can see, the purpose of DELETE clause is to delete the row which is more than 30 seconds old.  


  For some reason, I get a compile error in DELETE statement.  


The reason might be in the fact that the two intervals you compare are of different types. It could be hard to compare them directly with the current state of timestamp and interval technology.

www.teradataforum.com/l030515a.htm explains how to calculate the difference between two timestamps in good old seconds.


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: 15 Jun 2023