Categories:: Conversion functions

TRY_TO_DECFLOAT¶

A special version of TO_DECFLOAT that performs the same operation (that is, converts an input expression to a DECFLOAT), but with error-handling support. If the conversion can’t be performed, it returns a NULL value instead of raising an error.

For more information, see Error-handling conversion functions.

Syntax¶

TRY_TO_DECFLOAT( <string_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.

Usage notes¶

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

Returns¶

This function returns a value of DECFLOAT data type.

If there is a conversion error, the function returns NULL.

Examples¶

This example uses the TRY_TO_DECFLOAT function:

SELECT TRY_TO_DECFLOAT('3.1415926'), TRY_TO_DECFLOAT('Invalid');

Copy

+------------------------------+----------------------------+
| TRY_TO_DECFLOAT('3.1415926') | TRY_TO_DECFLOAT('INVALID') |
|------------------------------+----------------------------|
| 3.1415926                    | NULL                       |
+------------------------------+----------------------------+

For additional examples, see TO_DECFLOAT.