Archives of the TeradataForum

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

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

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.

Thanks

Nitin

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