Archives of the TeradataForum

Message Posted: Mon, 05 Sep 2005 @ 10:44:00 GMT

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

I'm trying to perform the following query:

     select ActArriveDTM, SchedArriveDTM
     ,cast((extract(day From (ActArriveDTM - SchedArriveDTM day(4) To minute)) * 1440) +
      (extract(hour from (ActArriveDTM - SchedArriveDTM day(4) To minute)) * 60) +
      (extract(minute From (ActArriveDTM - SchedArriveDTM day(4) To minute))) as
     INTEGER)
     from Table

ActArriveDTM and SchedArriveDTM are defined as timestamp(6). This returns the expected result (i.e. the number of minutes between the two timestamps) except where the number of days between the two timestamps is greater than 9,999. Unfortunately, some of my data does indeed do this. In these cases an error is returned, 7453: Interval field overflow.

Is there a way to extend it so that more than 9,999 days can be considered?

Mike

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