Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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.7k 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
2 answers
0 votes
1 answer
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...