Conversion Methods Used by the UTC Conversion Utility
This topic is part of Converting Historical Data to UTC.
The UTC conversion utility uses the following conversion methods:
SERVER_TIME. Conversion will be done according to the time zone of the server, as specified in the file server_time.inp. This method is used for date and time values that are not associated with a user.
You must use the correct syntax in the server_time.inp file. If the exact values are not specified, then the UTC conversion utility will not work. Use the time zone setting for your operating system to determine the correct values for this syntax. Enter the value and region (in quotation marks), on the second line of the server_time.inp file.
Here is an example for U.S. Central Standard Time (CST):
[GLOBAL] SERVER_TIME: "(GMT-06:00) Central Time (US & Canada)";
CREATED_BY. Conversion will be done according to the time zone of the user who created the record. The UTC conversion utility will look up the profile of the user who created the record being converted, and derive the corresponding time zone. In general, this conversion method is appropriate for converting data created by individual users, where creation time is relevant.
An example of this type of data would be service requests originally created by users in multiple time zones, where for each record the time stamp before conversion is in the user’s local time. In this case, you might choose to modify the input file s_srv_req.inp to use CREATED_BY instead of SERVER_TIME. Each record’s time stamp will be converted to UTC based on the user’s time zone.