Level 75
For money everytime use decimal. You can save there cents. https://www.noelherrick.com/blog/always-use-decimal-for-money
Apr 28, 2020
4
Level 2
Which money datatype to use ?
If I am building an e-commerce application, which datatype is best to for price field?
-
should I use
integerand store everything as cents? or usedecimal? -
is there any disadvantage of using
decimal?
Level 104
Integer cents gives me all the precision I need.
Level 73
I would use integer and store it in cents, much easier for calculation and avoiding the database rounding issues.
As an example:
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
Level 18
That's what Michael Dyrynda says: https://twitter.com/michaeldyrynda/status/1253516294571175938
;-)
Please or to participate in this conversation.