Fortinet Document Library

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:

Version:


Table of Contents

Administration Guide

SQL functions for formatting and converting data types example

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.

SQL functions for formatting and converting data types example

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.