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