[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