Archives of the TeradataForum
Message Posted: Wed, 15 Mar 2006 @ 15:43:53 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|