8. SQL Statements : SET : Money_prec
 
Share this page                  
Money_prec
SET MONEY_PREC specifies the number of decimal places to be displayed for money values. This option corresponds to the Ingres environment variable II_MONEY_PREC and is assigned the same values. Valid values are 0, 1, and 2. The default is 2 (for decimal currency).