Skip to main content

1E 23.11 (SaaS)

IPV4STRTOINT

Function

IPV4STRTOINT

Action

Converts an IPv4 address into an integer.

Parameters

(string) IPv4 Address in print notation, for example "10.20.30.45"

Return values

(integer) The IPv4 Address represented as an integer, for example 169090605 = (256^3 * 10) + (256^2 * 20)+ (256 * 30) +(45)

Examples

// Input is "10.20.30.45"
// Returns 169090605
SELECT IPV4STRTOINT("10.20.30.45") AS Integer;

Notes

This function is useful when comparing IP Addresses. Does not support IPv6.

In this section: