Re:9999999999999999.0 – 9999999999999998.0
by dotancohen on Sunday January 06, 2019 @08:47AM
(#18838270)
Even with money I use integers. Instead of dollars (or local currency), I store values internally as pennies (or local equivalent 1/100 of main currency). Sometimes when working with interest I'll need to work with floats, and some databases I have values stored as DECIMAL(8,2) instead of INT, but for the most part I've saved quite a few headaches by keeping my values in INTs.
[ Parent
| on HN ]
Re:9999999999999999.0 – 9999999999999998.0
by loa-in-backup on Tuesday January 08, 2019 @09:48AM
(#18855799)
There are currencies that have the lowest value coin as 1/20 of main coin.
Re:9999999999999999.0 – 9999999999999998.0
by CamouflagedKiwi on Sunday January 06, 2019 @10:10AM
(#18838675)
That seems okay until you need to track sub-penny accuracy somewhere, then you have a big problem.
Lots of applications don't need that, but a surprising amount do, so it's not a global solution.
Re:9999999999999999.0 – 9999999999999998.0
by hakfoo on Sunday January 06, 2019 @02:49PM
(#18840171)
But there's still a minimum significant value which can be defined from the problem space. Do DECIMAL(16,8) or whatever.
In some situations, there may even be industry or legal standards as to what can be considered rounding noise.