Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.3 |  CUBRID 9.0.0 | 

INET_ATON Function

Description

The INET_ATON function receives the string of an IP address and returns a number. When an IP address string such as 'a.b.c.d' is entered, the function returns a x 2563 + b x 2562 + c x 256 + d. The return type is BIGINT.

Syntax

INET_ATON( ip_string )

  • ip_string: IPv4 address string
Example

In the following example, 192.168.0.10 is calculated as 192 x 2563 + 168 x 2562 + 0 x 256 + 10

.

SELECT INET_ATON('192.168.0.10');

 

   inet_aton('192.168.0.10')

============================

                  3232235530