float function

Casts the value expr to FLOAT.

Syntax

float(expr)

Arguments

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

Returns

A FLOAT.

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

See cast function for details.

Examples

> SELECT float('5.2');
 5.2