Reference Guide > TDV Support for SQL Functions > Character Functions > INET_NTOA
 
INET_NTOA
Given a numeric IPv4 network address in network byte order, returns the dotted-quad string representation of the address as a string in the connection character set. INET_NTOA() returns NULL if it does not understand its argument.
Syntax
INET_NTOA(expr)
Example
SELECT INET_NTOA(201328137);
The above query returns 12.0.6.9