Hello,
I am interested in how the CURRENT TIMEZONE value is calculated. I know this value represents the offset used to get the GMT time. We're doing DST testing and have already applied the OS (AIX 5.2) patch. CURRENT TIMESTAMP returns the correct value after March 11th 2007 but CURRENT TIMEZONE still returns the old value (i.e. 5 hours instead of 4 hours). Only after the system date changes to April 1st 2007 (2 am) which was supposed to be the old DST date, the value of CURRENT TIMEZONE gets updated to 4 hours. I'm wondering if we missed a patch or if the latest FP14 would fix this. We're currently on FP10.

Thanks in advance for your help.
Ioan.

You'll need to apply a DB2 patch, obviously.

http://www-1.ibm.com/support/docview...=utf-8&lang=en