Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2005 @ 14:45:33 GMT

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

Subj:   Re: Interval Overflow Error
From:   Victor Sokovin

  I am trying to find the difference between two timestamps which results in seconds  

If it is the third party code which you cannot modify, then the answer is negative, and you have just provided the explanation for it.

If you can modify the metric definition then you can use INTERVAL types other than DAY(4) and/or the EXTRACT function. The latter helps extracting various elements such as year, month, day etc. There are many examples in the archives of this forum.



  <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