Archives of the TeradataForum
Message Posted: Wed, 26 Feb 2003 @ 10:46:19 GMT
By default precision used for the INTERVAL HOUR is two digits. This can be increased to a maximum of four digits by the following
SELECT CallDetail.callTime + CAST(CallDetail.actionCode AS INTERVAL
Basically the overflow error is because the actionCode field contains data greater than 99.
By using the above SQL, it will increase the max value allowed to 9999.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|