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