NUMBER_TO_IP
Syntax
NUMBER_TO_IP(<integer>)
Description
IPv4 addresses are normally represented in blocks of 8 bits separated by decimal points (known as dot-decimal notation). NUMBER_TO_IP converts an integer between 0 and 4294967295 to an IPv4 addresses in dot-decimal notation returned as a string.
Examples
Column1 | IP_TO_NUMBER returns |
---|---|
3564776253 | 212.122.43.61 |
2362641283 | 140.211.11.131 |
4294967295 | 255.255.255.255 |
0 | 0.0.0.0 |