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 |