Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 15 Mar 2006 @ 15:43:53 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Date Diff and Error 7453 - Overflow
From:   Chaturvedi, Nitin

Hi All,

I have a requirement of finding the diff. between two dates (data type timestamp) in mins.

I did following

     ((DATE_TIME1  - DAte_time2) day(4) to second(6)) as diff_time,
     extract (day from diff_time) * 24*60 as diff_day_min,
     extract (hour from diff_time) * 60 as diff_hr_min,
     extract (minute from diff_time) as diff_min,
     (dwn_day_min + dwn_hr_min + dwn_min ) as total_diff_time

I ended with error 7453-- Overflow.

I think it is due to day(4) to Second(6) because if diff is more then 30 days then it is going more then 6 digits for seconds.

How can i solve this problem? Or Any one can any suggest other way to find diff in minutes.



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023