IP_TO_NUMBER

Owned by Juliane Wetzel
Feb 07, 2020
1 min read

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