| ANSI | DB2 | SQL/DS | XDB |
|---|---|---|---|
| X | X |
Converts a number into the floating point representation of the number, as if the value were assigned to a FLOAT field. The format appears below:
FLOAT(x)
In DB2 compatibility mode, the parameter x cannot be a string. In XDB mode, x can be a string.