18. Working with Data Types and Data Display Formats : Data Types : Money Data Type
Share this page                  
Money Data Type
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:
Currency symbol
Decimal separator
Number of decimal places
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.