Link Search Menu Expand Document

TO_DOUBLE

Converts a string to a numeric DOUBLE data type.

Syntax

TO_DOUBLE(<exp>)
Parameter Description
<expr> Any numeric data types or numeric characters that resolve to a VARCHAR, TEXT, or STRING data type.

Example

SELECT
	TO_DOUBLE('100');

Returns: 100