Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Floating Point Approximations.
paul c wrote:
> Bob Badour wrote:
>
>> ... >> The epsilon would be 16 times larger for BCD floats. >> ie. 5e-7 versus 2^-25
Nope: 0.5 millionths versus 0.0298 millionths scaled by the exponent part of the float.
For floating point representations, epsilon is the rounding factor, which is half the least significant digit of the mantissa. If I recall correctly, a 32-bit BCD float has a 6 decimal digit mantissa with a 2 decimal digit exponent. A 32-bit binary float has a 24 bit mantissa with an 8 bit exponent. Received on Wed Mar 28 2007 - 19:37:56 CDT