ipv4

Description

Returns an IPv4 address representation of the argument value.

Integers are treated as an integer representation of the IP address and strings are treated as IP address string literals. Variant types are treated as either a string or integer depending on the data in each row.

Return type

ipv4

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

ipv4(value)

Argument

Type

Optional

Repeatable

Restrictions

value

ipv4, string, int64 or variant

no

no

none

Examples

make_col ip_address:ipv4('127.0.0.1')

Create a column ‘ip_address’ which has an IP address value of 127.0.0.1

make_col ip_address:ipv4(3232235521)

Create a column ‘ip_address’ which has an IP address value of 192.168.0.1