VeloDB Cloud
SQL Reference
SQL Functions
Scalar Functions
Ip Functions
IPV4_TO_IPV6

IPV4_TO_IPV6

Description

Convert ipv4 type address to ipv6 type address.

Syntax

IPV4_TO_IPV6(<ipv4>)

Parameters

ParameterDescription
<ipv4>An IPv4 type address

Return Value

Returns the converted IPv6 type address.

Example

select ipv6_num_to_string(ipv4_to_ipv6(to_ipv4('192.168.0.1')));
+----------------------------------------------------------+
| ipv6_num_to_string(ipv4_to_ipv6(to_ipv4('192.168.0.1'))) |
+----------------------------------------------------------+
| ::ffff:192.168.0.1                                       |
+----------------------------------------------------------+