Failure 7453 Interval field overflow for Timestamp

Database
Visitor

Failure 7453 Interval field overflow for Timestamp

I have below code in my SQL which gives error as 'Failure 7453 Interval field overflow'.

((FirstRespTime-StartTime) hour(2) to second(2))

Above code executing fine in Teradata 14/13. But recently we upgraded our system to Teradata V15 and its give an error.

Any help would be appreciated.Thanks

1 REPLY
Teradata Employee

Re: Failure 7453 Interval field overflow for Timestamp

Hi 

please change the value hour (2) to (4) and second (2) to (6)

  ((a.firststeptime - a.StartTime) HOUR(4) TO SECOND(6) ) )

i hope this help