Time Zone Codes

IMPORTANT

Read more about Data Workbench’s End-of-life announcement.

Information about the Time Zone codes and formats.

Most time-based parameters in the data workbench server are specified in the following format:

  • Month DD , YYYY HH :MM :SS TZone
  • Example: August 13, 2013 22:30:00 EST

Time zones are expressed in a system-independent time zone format (Coordinated Universal Time) of the following format:

  • UTC +hhmm dstrules

The sign (+) can be either a plus (+) or a minus (-) sign, and hhmm is the offset from UTC in hours and minutes. The optional variable dstrules specifies a set of rules to implement Daylight Saving Time or a similar clock-shifting policy.

If you specify dstrules, a tab-delimited file named dstrules.dst must be present within the Dataset\TimeZone directory of either the Base profile (for configuration files that are not associated with a particular dataset) or the dataset profile (for configuration files that are dataset-specific). The file specifies a time-zone independent set of rules for Daylight Saving Time. You can have different sets of rules for different years. The DST.dst file provided by Adobe in the Base profile specifies the standard U.S. rules established by the Energy Policy Act of 2005 (in effect starting 2007) and the U.S. rules for prior years.

Sample time zone entries are listed below:

  • U.S. Eastern Daylight Time: Time Zone = string: UTC -0500 DST
  • UTC time with no offset and no dstrules (corresponding to GMT): Time Zone = string: UTC -0000

When this format is used, the system time zone of data workbench server, data workbench, and Report machines need not be the same as the specified time zone. In addition, all active dataset profiles on a data workbench server machine need not have the same time zone setting.

The following table contains the list of codes you can use to specify time zones in time-based parameters.

Time Zone Code Table

If you are implementing Daylight Saving Time or a similar clock-shifting policy, you must save the .dst file containing the appropriate rules in the profile name \Dataset\Timezone directory on the data workbench server machine.

Code Time Zone Offset from GMT
gmt Greenwich Mean 0
est Eastern Standard 5
edt Eastern Daylight 5
cst Central Standard 6
cdt Central Daylight 6
mst Mountain Standard 7
mdt Mountain Daylight 7
pst Pacific Standard 8
pdt Pacific Daylight 8

Business.Adobe.com resources

Docs links
Contribution Analysis Advertising Analytics Mobile Analytics Data Ingestion Identity Management Analytics

On this page