FLOAT

FLOAT

Syntax

FLOAT (<numberstringBooleandate,>)

Description

Converts a numberstringBoolean, 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 type

Column1

FLOAT returns

Data field type

Column1

FLOAT returns

string

27

27.0

string

33

33.0

string

100

100.0

Boolean

false

0.0

Boolean

true

1.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

number

6

6.0

number

12

12.0