/

FLOAT

FLOAT

Jan 30, 2018

Syntax

FLOAT (<number, string, Boolean, date,>)

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