On 2002-03-15 22:29:46 -0500, Mark Riehl wrote: > Here's what's actually in the database: > +----------------+----------------+ > | float_col | double_col | > +----------------+----------------+ > | 1007575936.000 | 1007575930.907 | > | 1007575936.000 | 1007575930.951 | > | 1007575936.000 | 1007575931.029 | > +----------------+----------------+ > > These numbers aren't too large to fit into a float - any idea what's causing > the problem? Am I missing something obvious?
Yes. They are too *long* to fit into a float. A float is only good for
about 6 decimal digits. The next lower float value is 1007575872.
hp
--
_ | Peter J. Holzer | My definition of a stupid question is
|_|_) | Sysadmin WSR / LUGA | "a question that if you're embarassed to
| | | [EMAIL PROTECTED] | ask it, you stay stupid."
__/ | http://www.hjp.at/ | -- Tim Helck on dbi-users, 2001-07-30
msg09648/pgp00000.pgp
Description: PGP signature
