Setting the database time zone

For FTM 3.0.0 or later, support is provided for specifying the time zone 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 time zone behavior of FTM is used, except that the timestamps in the Operations and Administration Console (OAC) are correctly interpreted to be in the viewing time zone. For more information, see Date and time search criteria and Setting user preferences. For the most recent list of accepted time zone names, see Time Zone Database.
Other or blank
This option indicates that the previous time zone behavior of FTM is used, without support for conversion in the OAC.
For FTM 3.0.0, Fix Pack 4 or later, the following time zone-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 time zone that is needed. The default value is UTC.
    Note: The correct version of the FTM_TIMESTAMP() function is created automatically.
For FTM 3.0.0 to FTM 3.0.0, Fix Pack 3, the following time zone-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 time zone that is needed. 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 time zone mapping functions.