Monday, February 20, 2012

Money data type format

Why does SQL add 4 zeros at the end of a money data type? I have to format my strings once they are retrieved because of this. I am not sure if I did something wrong, but shouldn't it only have 2 trailing zero's?No, thats the standard format. If you want 2 decimals, you need to use Decimal datatype with precision set to 2.

No comments:

Post a Comment