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 an IPv6 or IPv4 internet address from its binary representation to its text representation.
INET6_NTOA( bin_str )
String.
The return string is lowercase. It has a maximum length of 39 characters.
If the argument is not a valid address - returns NULL.
SELECT INET6_NTOA(UNHEX('0A000101'));
****
+-------------------------------+
| INET6_NTOA(UNHEX('0A000101')) |
+-------------------------------+
| 10.0.1.1 |
+-------------------------------+
SELECT INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F'));
****
+-------------------------------------------------------+
| INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F')) |
+-------------------------------------------------------+
| 48f3::d432:1431:ba23:846f |
+-------------------------------------------------------+
SELECT INET6_NTOA(INET6_ATON('2001:db8:8714:3a90::12'));
****
+--------------------------------------------------+
| INET6_NTOA(INET6_ATON('2001:db8:8714:3a90::12')) |
+--------------------------------------------------+
| 2001:db8:8714:3a90::12 |
+--------------------------------------------------+
SELECT HEX(INET6_ATON(INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F'))));
****
+------------------------------------------------------------------------+
| HEX(INET6_ATON(INET6_NTOA(UNHEX('48F3000000000000D4321431BA23846F')))) |
+------------------------------------------------------------------------+
| 48F3000000000000D4321431BA23846F |
+------------------------------------------------------------------------+