Why not use Double or Float to represent currency?
Because of precision: floats and doubles cannot accurately represent the base 10 multiples that we use for money.
- from
- Billing
- added
- 2026-10-10
- likes
- 0
similar
-
Never Use Floats for Money husobee.github.io
“This is precisely the problem we have when trying to represent 10^-1, or 0.1 in binary. There is not an exact binary representation of 0.1 or 0.01.”
-
Floating point number floating-point-gui.de
This representation can encode numbers at very different magnitudes with a limited amount of digits by letting the radix point float instead of being fixed in place.
-
Twenty five thousand dollars of funny money web.archive.org
Same error as above at Google Ads, or the danger of separating your pennies from your dollars, where $250 internal coupons turned into $25,000. My advice: get rid of integers and floats for monetary values. Use decimals. Or fallback to strings and parse them, don't validate.
-
Decimal Point Error in Etsy's Accounting System web.archive.org
The importance of types in accounting software: missing the decimal point ends up with 100x over-charges.
-
-
Floating Point Math 0.30000000000000004.com
“Your language isn't broken, it's doing floating point math. (…) This is why, more often than not, 0.1 + 0.2 != 0.3.”
Billing › Business Intelligence > Data Engineering: “Because of precision: floats and doubles cannot accurately represent the base 10 multiples that we use for money.”