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