FLOAT

Syntax

FLOAT (<numberstringBooleandate,>)

Description

Converts a number, string, Boolean, or date into a float value. This function is useful if another function's arguments require a float value.

If the data contained in the strings are not integers (words, dates, IP addresses), FLOAT returns an error message.

Examples

Data field typeColumn1FLOAT returns
string2727.0
string3333.0
string100100.0
Booleanfalse0.0
Booleantrue1.0
date
Feb 23, 1990 12:00:00 AM
635,727,600,000.0
date
Jun 2, 1955 12:00:00 AM
-460,256,400,000.0
number66.0
number1212.0