From: Michael T. Babcock [EMAIL PROTECTED]
Kenneth Hylton wrote something about SQL or QUERYs:
I NEVER use float or double to store values like you appear to be doing...
FWIW, all of our financial database software stores values in either pennies or
tenths of a cent, not dollars, to avoid
Oh, for BCD floating point.
My first computer with a language (SWTP 6800) had BCD math.
It had something like 6 byte mantissa and a 1 byte exponent.
That would give 11 digits with e +-99
Maybe we should have BCD data types.
Jan Steinman wrote:
From: Michael T. Babcock [EMAIL PROTECTED]
Kenneth
to worry about rounding errors. (unless you're recording
truly enormous sums of money...)
-JF
-Original Message-
From: gerald_clark [mailto:gerald_clark;suppliersystems.com]
Sent: Wednesday, October 23, 2002 10:10 AM
To: Jan Steinman
Cc: [EMAIL PROTECTED]
Subject: Re: Rounding floats