Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision.

Allowed values

Integer, between 0 and 127, inclusive, and less than the value specified for the precision database option

Default

6

Scope

PUBLIC role | For current user | For other users | |
---|---|---|---|

Allowed to set permanently? | Yes, with SET ANY PUBLIC OPTION | No | No |

Allowed to set temporarily? | No | No | No |

Remarks

Precision is the total number of digits in a number and does not include the decimal point. The scale option specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum precision. For example, the number 3.1415926 has a precision of 8 and a scale of 7.

Multiplication, division, addition, subtraction, and aggregate functions can all have results that exceed the maximum precision.