Reference Guide > TDV Support for SQL Functions > Numeric Functions > QUANTIZE
 
QUANTIZE
The QUANTIZE function returns a DECFLOAT value that is equal in value (except for any rounding) and sign to the first argument and that has an exponent that is set to equal the exponent of the second argument.
Syntax
QUANTIZE(expr1,expr2)
Example
SELECT QUANTIZE(4.112, DECFLOAT(0.01))
Returns: 4.11