0 votes
1 view
in SQL by (20.3k points)

Seems like Money type is discouraged as described here

My application needs to store currency, which datatype shall I be using? Numeric, Money or FLOAT?

1 Answer

0 votes
by (40.4k points)

Don't use float or float like datatype to represent currency because if you do so, the financial report's bottom line figure may come incorrectly by + or - a few dollars.

 Numeric data type can be used with forced 2 unit precision for currency. 

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...