Archives of the TeradataForum
Message Posted: Mon, 05 May 2003 @ 18:14:42 GMT
| 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
| 
