INET_NTOA()

Documentation

VoltDB Home » Documentation » Using VoltDB

INET_NTOA()

INET_NTOA() — Converts an IPv4 internet address from a numeric value to a string

Synopsis

INET_NTOA( {numeric-value} )

Description

The INET_NTOA() function converts a BIGINT value representing an IPv4 internet address to its corresponding dot representation as a VARCHAR value. Or, if the argument is null, the function returns a null VARCHAR as the result.

You can use the INET_ATON() function to perform the reverse operation, from a VARCHAR IPv4 address in dot notation to a BIGINT value, or you can use the INET6_ATON and INET6_NTOA functions to perform similar operations on IPv6 addresses.

Examples

The following example converts a BIGINT representation of an internet address into its string representation for output.

SELECT INET_NTOA(ip), owner FROM Address
   WHERE owner=? ORDER BY ip;