INET_NTOA
Converts a 32-bit integer to an IPv4 address.
Syntax
INET_NOTA ( int32 )
Arguments
int32: an integer.
Return Type
String, a dotted-quad IP address, eg “1.2.3.4” or NULL if the IP address cannot be parsed.
Note
This function does not handle IPv6 addresses.
Examples
SELECT INET_NTOA(16909060); **** +---------------------+ | inet_ntoa(16909060) | +---------------------+ | 1.2.3.4 | +---------------------+
SELECT INET_NTOA(169090600000000000); **** +-------------------------------+ | INET_NTOA(169090600000000000) | +-------------------------------+ | NULL | +-------------------------------+
Related Topics