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