3 ms·
So, best way to store currency amounts? Cents or decimal? Would the answer change based on platform or DB (i.e., Python, Postgres)?
by pbreit 11y ago
So, best way to store currency amounts? Cents or decimal? Would the answer change based on platform or DB (i.e., Python, Postgres)?
- AlterEgo20 11y agoAny SQL DBMS is able to store and handle NUMERIC data type. It is a binary decimal with any precision you may want. Some of the DBMS's also have dedicated currency types.