int64_to_ipv4¶
Description¶
Converts integer-encoded IPv4 addresses to dotted-quad notation.
Given an integer that represents an IPv4 address in big-endian (network) byte order, return the corresponding dotted-quad representation as a string. Returns null if the input number is negative or too large.
Return type¶
string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
int64_to_ipv4(int)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
int |
int64 |
no |
no |
none |
Examples¶
make_col ipint:int64_to_ipv4(ipint)
Assuming there’s an integer input representing an IPv4 address in big-endian (network) byte order, return dotted-quad string version of that address.
ipint (input) |
ipstr (output) |
|---|---|
-1 |
null |
0 |
0.0.0.0 |
134743044 |
8.8.4.4 |
167772161 |
10.0.0.1 |
2130706433 |
127.0.0.1 |
2147549699 |
128.1.2.3 |
2887647747 |
172.30.2.3 |
3232235523 |
192.168.0.3 |
3355509251 |
200.1.2.3 |
4294967295 |
255.255.255.255 |
4294967296 |
null |