Jonathon <[EMAIL PROTECTED]> wrote: > I was just curious if there is a way to convert an integer > representation of an IP address that I store in my DB, to it's string > equivalent (xxx.xxx.xxx.xxx)? I would also need to convert it to > host-byte order as well.
select (ip >> 24) || '.' || ((ip >> 16) & 255) || '.' || ((ip >> 8) & 255) || '.' || (ip & 255) from mytable; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
