Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2005 @ 14:06:57 GMT


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


Subj:   Interval Overflow Error
 
From:   Kambhoji, Naveen Ram Prasanna

Hi All,

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

     SELECT ( CAST( CAST(CURRENT_TIMESTAMP AS CHAR(19) ) AS
            TIMESTAMP(0))- CAST( '1970-01-01 00:00:00' AS TIMESTAMP(0))
            ) DAY(4) TO SECOND

We have a metric ( Microstrategy Jargon) that makes use of above calculation. Since DAY Interval will support only 4 Decimals (9999 days = Approximately 27 Years) I am getting an Interval overflow error. Here I need to have more precision for DAY which Teradata Currently doesn't support. Is there any round about way of doing this calculation? Please help me out.


Regards,

Prasanna .



     
  <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