[TriLUG] Money in mysql
Phillip Rhodes
mindcrime at cpphacker.co.uk
Thu Oct 14 05:57:06 EDT 2004
Phillip Rhodes wrote:
> Pretty precise,
> but the problem then becomes if you multiply the result by
> 7, you won't get back your original number. This can cause
> unexpected glitches if you're not careful.
I should have said, "you won't necessarily get back your original
number." And therein lies the rub. Depending on what happens
with the truncation / rounding, you may or may not get the
results you intuitively expect, on any given occassion.
TTYL,
Phil
More information about the TriLUG
mailing list