Archives of the TeradataForum

Message Posted: Tue, 21 Apr 2015 @ 16:52:19 GMT

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

<-- Anonymously Posted: Tuesday, April 21, 2015 09:30 -->

Both TD and Oracle internally use 126 bits precision which is slightly more than 38 decimal digits (but less than 39).

The problem comes when we convert to external representation and back, we lose some precision.

The only workaround I can think of is instead of X to export two values, say Y = X/32768 and Z = X-Y. Load the two values and then recombine.

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