Name

atoi — Convert a string to an integer

Synopsis

atoi ( in arg string );
 

Description

atoi returns its argument as an integer. If the string cannot be parsed and converted to a valid integer, a value 0 is returned.

Parameters

arg

A string input parameter

Return Types

The string converted to an integer. If the string is a number then the absolute value of the literal will be returned as an integer. Otherwise 0 is returned.

Examples

Example 24.18. Simple examples

SQL> select atoi('1.23456789');
callret
INTEGER
_______________________________________________________________________________

1

1 Rows. -- 5 msec.

SQL> select atoi ('Cadena de los patos amarillos');
callret
INTEGER
_______________________________________________________________________________

0

1 Rows. -- 4 msec.


See Also

atof