Money Datatypes

The money datatypes, money and smallmoney, store monetary data.

You can use these datatypes for U.S. dollars and other decimal currencies, although SAP ASE provides no means to convert from one currency to another. You can use all arithmetic operations except modulo, and all aggregate functions, with money and smallmoney data.

Both money and smallmoney are accurate to one ten-thousandth of a monetary unit, but round values up to two decimal places for display purposes. The default print format places a comma after every three digits.