Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Teradata Decimal Precision issue
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019