Skip to main content

INET_NTOA

Converts a 32-bit integer to an IPv4 address.

Syntax

INET_NOTA( <int32> )

Aliases

Return Type

String.

Examples

SELECT IPV4_NUM_TO_STRING(16909060), INET_NTOA(16909060);

┌────────────────────────────────────────────────────┐
│ ipv4_num_to_string(16909060) │ inet_ntoa(16909060)
├──────────────────────────────┼─────────────────────┤
1.2.3.41.2.3.4
└────────────────────────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today