int64_to_ipv4
int64_to_ipv4(int: int64) -> string
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.
Domain
This is a scalar function (calculates a single output value for a single input row).
Categories
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 |
Updated 8 days ago