On 2016-11-30 2:43 PM, Keith Medcalf wrote:
You were given a good recommendation save everything in "cents". Which
might also be a good solution depending on the underlying language you
use. as you can't store money in a float!
And why can you not store money in a float?
Unlike say measured data like temperature or rainfall, which are inherently
inexact, money is not measured and is considered exact information, at least in
typical cases of recording transactions, so needs to be represented in an exact
format. You don't want your bank balance to be changing by different values
than the exact amount you insert or withdraw, do you? -- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
