Generating Time Zone Offsets
Access the Time Zone Offset Generation page (click the Generate Query Offsets button on the Time Zone IDs page).
To generate query offsets:
-
Enter a start date and an end date.
Select a reasonable range of dates. With the time zones delivered with the PeopleSoft system, more than 100 rows are generated for each year.
-
Click OK.
The data is generated for the table. Any existing data for the same range of dates is overwritten.
Note:
If you receive an error about missing daylight saving time IDs, the error can be corrected by adding entries to the PSDSTTIME table on the DST IDs page.
For example, the following data from the PSTZOFFSET table represents one time zone, EST, for a two-year period, from January 1, 1999, to January 1, 2001. It is based on a system with PST as the base time zone. When you generate query offsets, the PSTZOFFSET table contains similar data for all the time zones defined in the PSTIMEZONE table.
| TIMEZONE | STARTDATETIME | ENDDATETIME | BASEOFFSET | TIMEZONELABEL |
|---|---|---|---|---|
|
EST |
1999-01-01 00:00:00.000 |
1999-04-03 23:00:00.000 |
180 |
EST |
|
EST |
1999-04-03 23:00:00.000 |
1999-04-04 02:00:00.000 |
240 |
EDT |
|
EST |
1999-04-04 02:00:00.000 |
1999-10-30 23:00:00.000 |
180 |
EDT |
|
EST |
1999-10-30 23:00:00.000 |
1999-10-31 02:00:00.000 |
120 |
EST |
|
EST |
1999-10-31 02:00:00.000 |
2000-04-01 23:00:00.000 |
180 |
EST |
|
EST |
2000-04-01 23:00:00.000 |
2000-04-02 02:00:00.000 |
240 |
EDT |
|
EST |
2000-04-02 02:00:00.000 |
2000-10-28 23:00:00.000 |
180 |
EDT |
|
EST |
2000-10-28 23:00:00.000 |
2000-10-29 02:00:00.000 |
120 |
EST |
|
EST |
2000-10-29 02:00:00.000 |
2001-01-01 00:00:00.000 |
180 |
EST |
The first row of data shows that from January 1, 1999, at midnight, until April 3, 1999, at 11 p.m., (base time—PST, in this case), the offset between EST and the base time zone is 180 minutes, meaning that EST is 180 minutes ahead of PST. The label for EST during this period is EST.
The second row shows that from April 3, 1999, at 11 p.m., until April 4, 1999, at 2 a.m., there is a three-hour time period during which EST is 240 minutes ahead of PST. This is because EST has changed to daylight saving time, but PST hasn’t changed yet. The label for EST during this period is EDT, for eastern daylight time.