QUANTIZE

The QUANTIZE function returns a DECFLOAT value that is equal in value and sign to the first argument.

Example:

Quantize the following decimal floating-point values:

QUANTIZE(2.17, 0.001) ==> 2.170 
QUANTIZE(2.17, 0.01) ==> 2.17 
QUANTIZE(2.17, 0.1) ==> 2.2 
QUANTIZE(2.17, 1e+0) ==> 2 
QUANTIZE(2.17, 1e+1) ==> 0E+1