This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
TO_FLOAT
Converts a string to a numeric REAL data type.
Syntax
TO_FLOAT(<expression>)
| Parameter | Description |
|---|---|
<expression> | A numeric data type or numeric characters that resolve to a TEXT data type. |
Example
SELECT
TO_FLOAT('10.5');
Returns: 10.5