Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 05 May 2003 @ 18:14:42 GMT


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


Subj:   Re: Why it is rounding the last digit?
 
From:   Dempsey, Mike

The long term solution (it may be very long term) is for Spreadsheet vendors to start using an 8 byte floating point value instead of the current IEEE 4 byte standard.

All spreadsheets that I have used (including Microsoft Excel and the spreadsheet used within SQL Assistant) store floating point values (this includes 'Decimal' columns) in IEEE format. This format allows for 15 to 16 digits of accuracy ... with no way to improve it.

The only possible solution in SQL Assistant is therefore to display the data in character format. While this works it is a 'sub-optimal' solution ... for the reasons expressed in this email thread. (This is why it is NOT the default, and must be specifically requested via the Option setting.)

Mike Dempsey
Developer - Teradata SQL Assistant



     
  <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: 27 Dec 2016