INET_ NTOA
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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.
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
Last modified: April 4, 2023