📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

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 │ └────────────────────────────────────────────────────┘

Was this page helpful?