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