Link Search Menu Expand Document

TO_FLOAT

Converts a string to a numeric FLOAT data type.

Syntax

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

Example

SELECT
	TO_FLOAT('10.5');

Returns: 10.5