Archives of the TeradataForum
Message Posted: Tue, 21 Apr 2015 @ 16:52:19 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|