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
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