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 to DOUBLE.

Returns

A DOUBLE.

If expr is a STRING that cannot be parsed as a number, Databricks raises a CAST_INVALID_INPUT error.

Common error conditions

• CAST_INVALID_INPUT

Examples

SQL

> SELECT double('5.2');
 5.2

> SELECT double('abc');
  Error: CAST_INVALID_INPUT

Related functions

• cast function