Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007

    Question Unanswered: Current Timezone

    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.
    Last edited by irotar; 02-20-07 at 13:01.

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    You'll need to apply a DB2 patch, obviously.
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts