Introduction
Many developers like MONEY data type as it tends to be faster during computations and byte cheaper (arguably). Still in the next few examples, I am going to show an issue that can lead to possible loss of precision.
Examples
Let us try the following code:
The actual result is 0,054297 and by all mathematical rules should be rounded to 0,0543. Still, the query result is 0,0542.
Let's look at another example:
The actual result is 21,2939664 and the query returns 21,294.
This kind of behaviour is called banker's rounding. However, if you use SQL Server DB combined with .NET application, you may encounter precision loss as .NET doesn't use banker's rounding for decimal data type by default.
One of the possible solutions is to cast money to more precise data type before such operations. The following example works properly:
History
- 16th February, 2015: Initial version
