RE: Rounding floats

2002-10-23 Thread Jon Frisby
;t have 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 PROT

Re: Rounding floats

2002-10-23 Thread gerald_clark
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]> Kenne

Re: Rounding floats

2002-10-23 Thread Jan Steinman
>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 avoi

Rounding floats

2002-10-23 Thread Michael T. Babcock
Kenneth Hylton wrote something about SQL or QUERYs: I NEVER use float or double to store values like you appear to be doing. I always used DECIMAL so that they are stored as strings and you do not have problems associated with what you see here. I then have complete control over what is stored