The money data type contains decimal currency data. Great flexibility is provided with regard to the money data type. Using system variables, you can adopt the conventions of your local currency. These include:

For more information, see the system administrator guide for the system on which your database resides.

On input and output, money data is rounded to dollars and cents, pounds and pence, or other currency units. Arithmetic operations on money values retain precision as established by the II_MONEY_PREC environment variable/logical.

You can enter up to 14 digits into a column specified for the money data type. When displayed, money data can appear as up to 20 characters, allowing room for commas, currency signs, and place holder symbols.