FLOAT

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

Numeric to Float

Read syntax diagramSkip visual syntax diagram
>>-FLOAT--(--numeric-expression--)-----------------------------><

String to Float

Read syntax diagramSkip visual syntax diagram
>>-FLOAT--(--string-expression--)------------------------------><

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