Name
atof — Convert a string to single precision float
Synopsis
atof
( |
in arg string ); |
Description
atof returns its argument as a single precision floating point. If the string cannot be parsed and converted to a valid float, a value 0.0 is returned.
Parameters
arg
A string input parameter
Return Types
Single precision floating point
Examples
Example24.17.Simple examples
SQL> select atof('1.23456789');
callret
REAL
_______________________________________________________________________________
1.234568
1 Rows. -- 5 msec.
SQL> select atof ('Cadena de los patos amarillos');
callret
REAL
_______________________________________________________________________________
0.000000
1 Rows. -- 4 msec.
SQL> select atof (sprintf ('%f', 2.3423));
callret
REAL
_______________________________________________________________________________
2.342300
1 Rows. -- 5 msec.