Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
The CEEUTCO API has a bug where the value it returns does not change when a region changes from Daylight Savings Time to Standard Time.
The API, for example might return -5:00 for Central Daylight time, but after Daylight Savings Time ends, it returns -5:00 but should return -6:00.
The way to make this API return the correct value is to do the following:
- Change your system value QTIMZON to any value other than the current value.
- Change your system value QTIMZON back to the correct timezone value.
The CEEUTCO API will now return the correct time offset.
This bug also impacts the UTC offset recorded in your HTTP (web server) logs. The above fix corrects the web log issue as well.
This ClassAnova article contains an example program that will write your timezone related settings to the joblog.