It is recommended that all time sensitive data is stored in the time of the base time zone as defined on the installation options. This will prevent any confusion when analyzing data and will ensure that your algorithms do not have to perform any shifting of data that may be stored in different time zones.
The Time Zone entity is used to define all the time zones where your customers may operate. It is used by interfaces to help ensure data is stored correctly in the base time zone.
When designing your time zones, the first thing to determine is the base time zone. For an example, let's assume that your company's main office is in the US Central time zone. First, you need to define this time zone and define the seasonal time shift whose schedule it follows.
When designing your time zones, the first thing to determine is the base time zone. If, for example, your company's main office and all customers are located in the US Central time zone, you would first you need to define this time zone as well as the labels for standard time (default) and daylight savings time (shifted). Because (in this example) all business occurs in the US Central time zone, no other time zone entries are required:
| Time Zone | Time Zone Name | Default Label | Shifted Label |
|---|---|---|---|
| USCentral | US/Central | CST | CDT |
Once this is done you can link the time zone code to the installation option as the base time zone. Refer to Installation Options - Main for more information.
If your company does business beyond your local time zone, then you can define the other time zones where you may have customers or other systems with which you exchange data. Let's use the US time zones as an example. We'll define time zones for Eastern, Mountain, Pacific, and one for Arizona (which doesn't observe daylight savings time):
| Time Zone | Time Zone Name | Default Label | Shifted Label |
|---|---|---|---|
| USCentral | US/Central | CST | CDT |
| USEastern | US/Eastern | EST | EDT |
| USMountain | US/Mountain | MST | MDT |
| USArizona | US/Arizona | AST | |
| USPacific | US/Pacific | PST | PDT |
Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.19.2015 16:18:51 [F1_1424305131000]