FLOAT

The FLOAT function returns a floating point representation of a number or string.

Numeric to Float

Read syntax diagramSkip visual syntax diagramFLOAT (numeric-expression)

String to Float

Read syntax diagramSkip visual syntax diagramFLOAT (string-expression)

FLOAT is a synonym for the DOUBLE_PRECISION and DOUBLE functions. For more information, see DOUBLE_PRECISION or DOUBLE.