Pular para o conteúdo principal
Última atualização em

ip_network_first function

Applies to: check marked yes Databricks Runtime 18.2 and above

Returns the network portion of an IPv4 or IPv6 CIDR block in its canonical form.

This function is an alias for ip_network function.

Syntax​

ip_network_first ( cidr )

Arguments​

  • cidr: A STRING or BINARY value representing a valid IPv4 or IPv6 CIDR block.

Returns​

The same type as the input (STRING or BINARY), representing the canonical form of the network address.

The function returns NULL if the input is NULL.

Error conditions​

Examples​

SQL
> SELECT ip_network_first('192.168.1.100/24');
  192.168.1.0

> SELECT ip_network_first('10.32.1.5/16');
  10.32.0.0

> SELECT ip_network_first('2001:db8::1/32');
  2001:db8::

> SELECT ip_network_first('::ffff:192.0.2.128/120');
  ::ffff:192.0.2.0

> SELECT hex(ip_network_first(X'C0A8016418'));
  C0A80100

> SELECT ip_network_first(NULL);
  NULL

> SELECT ip_network_first('192.168.1.5');
  Error: INVALID_CIDR_BLOCK
Nesta página