Skip to main content

TRY_INET_ATON

try_inet_aton function is used to take the dotted-quad representation of an IPv4 address as a string and returns the numeric value of the given IP address in form of an integer.

Syntax

TRY_INET_ATON( <expr> )

Arguments

ArgumentsDescription
<expr>String.

Return Type

An integer.

Examples

SELECT TRY_INET_ATON('10.0.5.9');
+---------------------------+
| TRY_INET_ATON('10.0.5.9') |
+---------------------------+
| 167773449 |
+---------------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today