TRY_TO_NUMBER

​

Syntax

​

Scalar

try_to_number(value)

​

Arguments

​

Returns

• Type: DOUBLE
• NULL behavior: NULL input, an empty/unparseable string or a failed supported conversion returns NULL.

​

Properties

​

Usage notes

• Deterministic: The same inputs and settings produce the same result.

​

Examples

​

Typical behavior

SELECT try_to_number('3.5') AS "value", try_to_number('bad') AS invalid;

​

Negative and fractional text

SELECT try_to_number('-12.50') AS negative_number, try_to_number('0.25') AS fraction;

​

Limitations

• Only the one-argument form is implemented. Format, precision and scale arguments are rejected.

​

Related functions

• try_cast