NORMALIZE_DECFLOAT()

Returns the simplest, normalized form of a DECFLOAT

Result type

DECFLOAT

Syntax

NORMALIZE_DECFLOAT (decfloat_value)

Table 1. `NORMALIZE_DECFLOAT` Function Parameters
Parameter	Description
decfloat_value	Value or expression of type `DECFLOAT`, or cast-compatible with `DECFLOAT`

For any non-zero value, trailing zeroes are removed with appropriate correction of the exponent.

-- will return 12
select normalize_decfloat(12.00)
from rdb$database;

-- will return 1.2E+2
select normalize_decfloat(120)
from rdb$database;