Setting the database timezone

For FTM V3.0.0 or later, support is provided for specifying the timezone of timestamps that are contained in the database.

The following options are allowed:

UTC: All timestamps in the database are in Coordinated Universal Time.
Named timezones from the tz, or Olson, database: This option indicates that the previous timezone behavior of FTM is used, except that the timestamps in the OAC are correctly interpreted to be in the viewing timezone. For more information, see Date and time search criteria and Setting user preferences. For the most recent list of accepted timezone names, see Timezone database.
Other or blank: This option indicates that the previous timezone behavior of FTM is used, without support for conversion in the OAC.

For V3.0.0, Fix Pack 4 or later, the following timezone-related changes must be done manually before the installation scripts are run:

Edit the 02a-TimestampFunctions.sql file and update the INSERT statement for the Category='CORE'/Key ='DB_TZ' and set the value to the required timezone. The default value is "UTC".
Note: The correct version of the FTM_TIMESTAMP() function is created automatically.

For V3.0.0 to V3.0.0, Fix Pack 3, the following timezone-related changes must be done manually before the installation scripts are run:

Edit the 19-Config.sql file and update the INSERT statement for the Category='CORE'/Key ='DB_TZ' and set the value to the required timezone. The default value is "UTC".
Edit the 02a-TimestampFunctions.sql file and uncomment the indicated comment block to create the correct FTM_TIMESTAMP() function.

For more information about converting message timestamps to UTC, see ESQL timezone mapping functions.