Reference Guide
>
TDV Support for SQL Functions
>
Numeric Functions
>
NORMALIZE_DECFLOAT
NORMALIZE_DECFLOAT
The function returns a decimal floating-point value equal to the input argument in its simplest form with all trailing zeros removed.
Syntax
NORMALIZE_DECFLOAT(expr)
Example
SELECT NORMALIZE_DECFLOAT(1.210000)
Returns: 1.21