float function
Applies to: 
Databricks SQL Databricks Runtime
Casts the value expr to FLOAT. This function is a synonym for CAST(expr AS FLOAT). See cast function for details.
Syntax
float(expr)
Arguments
expr: An expression that can be cast toFLOAT.
Returns
A FLOAT.
Examples
SQL
> SELECT float('5.2');
5.2