Fortinet Document Library

Version:


Table of Contents

Cookbook

6.2.0
Download PDF
Copy Link

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.

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.