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

TRY_INET_NTOA



Takes an IPv4 address in network byte order and then returns the address as a dotted-quad string representation.

Syntax

TRY_INET_NTOA( <integer> )

Aliases

Return Type

String.

Examples

SELECT TRY_INET_NTOA(167773449), TRY_IPV4_NUM_TO_STRING(167773449); ┌──────────────────────────────────────────────────────────────┐ │ try_inet_ntoa(167773449) │ try_ipv4_num_to_string(167773449) │ ├──────────────────────────┼───────────────────────────────────┤ │ 10.0.5.910.0.5.9 │ └──────────────────────────────────────────────────────────────┘

Was this page helpful?