Archives of the TeradataForum

Message Posted: Wed, 26 Feb 2003 @ 10:46:19 GMT

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

Hi,

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
HOUR(4)) AS switchLocalTime
FROM CallDetail
WHERE CallDetail.mdn = '1231231234'
AND switchLocalTime > timestamp '2002-12-21 00:00:00'
AND switchLocalTime < timestamp '2002-12-21 23:59:59'

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.

Regards

Matthew Winter

Technical Architect
TPG IS, Design Authority
Teradata Certified Professional

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