SQL functions for formatting and converting data types

The following SQL functions can be used to format or convert different data types:

SQL function	Description
from_itime / from_dtime	Converts timestamp to formatted date/time.
ipstr	Converts srcip/dstip field from inet to string.
app_group_name	Groups similar application names.
root_domain	Groups similar hostnames.
vpn_trim	Groups similar VPN tunnels.
nullifna	Converts N/A to null.
logid_to_int	Trims logid.