Link Search Menu Expand Document

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