ToFloat
Summary
The ToFloat function converts numeric values and numeric strings to a Float.
Syntax
ToFloat(<numeric or numeric string>) |
Return Type
Float
Details
The minimum Float value is 1.4E-45 and the maximum Float value is 3.4028235E38.
Examples
select ToFloat(8.008), TypeNameOf(ToFloat(8.008)) from Empty();
select ToFloat('18753.23'), TypeNameOf(ToFloat('18753.23'))
from Empty();
Related Functions