Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Converts a 32-bit integer to an IPv4 address.
INET_NOTA ( int32 )
String, a dotted-quad IP address, eg ‘1.2.3.4’ or NULL if the IP address cannot be parsed.
+---------------------+
| inet_ntoa(16909060) |
+---------------------+
| 1.2.3.4 |
+---------------------+
SELECT INET_NTOA(169090600000000000);
+-------------------------------+
| INET_NTOA(169090600000000000) |
+-------------------------------+
| NULL |
+-------------------------------+
Related Topics