Categories:: Conversion functions

TO_DECFLOAT¶

Converts an expression to a decimal floating-point number (DECFLOAT).

See also:: TRY_TO_DECFLOAT

Syntax¶

TO_DECFLOAT( <expr> [ , '<format>' ] )

Copy

Arguments¶

Required:

expr: An expression of a numeric, character, or Boolean type.

Optional:

'format': If the expression evaluates to a string, then the function accepts an optional format model. For more information, see SQL format models. The format model specifies the format of the input string, not the format of the output value.

Returns¶

This function returns a value of DECFLOAT data type.

If expr is NULL, the function returns NULL.

Usage notes¶

The special values 'NaN' (not a number), 'inf' (infinity), and '-inf' (negative infinity) aren’t supported.

Examples¶

After creating a table with columns of different data types, call the TO_DECFLOAT function to convert the values in each of those columns:

CREATE OR REPLACE TABLE to_decfloat_demo (d DECIMAL(7, 2), v VARCHAR);
INSERT INTO to_decfloat_demo (d, v) SELECT 1.1, '2.2';
SELECT TO_DECFLOAT(d), TO_DECFLOAT(v) FROM to_decfloat_demo;

Copy

+----------------+----------------+
| TO_DECFLOAT(D) | TO_DECFLOAT(V) |
|----------------+----------------|
| 1.1            | 2.2            |
+----------------+----------------+