Skip to main content

SingleStoreDB v8.1

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

In this section: