double function

Casts the value expr to DOUBLE.

Syntax 

double(expr)

Arguments

  • expr: An expression that can be cast to DOUBLE.

Returns

A DOUBLE.

This function is a synonym for CAST(expr AS DOUBLE).

See cast function for details.

Examples 

> SELECT double('5.2');
 5.2