PM08377: Daylight saving causes timestamp when exporting to excel or text file to be off by an hour

Rational ClearQuest Fix Pack (8.0.0.1) for version 8.0
Rational ClearQuest Fix Pack 11 (8.0.0.11) for 8.0
Rational ClearQuest Fix Pack 12 (8.0.0.12) for 8.0
Rational ClearQuest Fix Pack 13 (8.0.0.13) for 8.0
Rational ClearQuest Fix Pack 14 (8.0.0.14) for 8.0
Rational ClearQuest Fix Pack 15 (8.0.0.15) for 8.0
Rational ClearQuest Fix Pack 16 (8.0.0.16) for 8.0
Rational ClearQuest Fix Pack 17 (8.0.0.17) for 8.0
Rational ClearQuest Fix Pack 18 (8.0.0.18) for 8.0
Rational ClearQuest Fix Pack 19 (8.0.0.19) for 8.0
Rational ClearQuest Fix Pack 20 (8.0.0.20) for 8.0
Rational ClearQuest Fix Pack 21 (8.0.0.21) for 8.0

APAR status

• Closed as program error.

Error description

• Daylight savings time causes the timestamp in the excel sheet or
  the text file to be off by an hour from the timestamp in the qu
  ery when doing an export to excel or text file for a Date/Time f
  ield.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Users encountered multiple incorrect date/time data issues
  in exported and printed query results.
  
  1) During Daylight Saving Time, exported, printed, base
  ClearCase integration-related date/time data was incorrectly
  displayed
  
  2) When using the LONG date format, the timezone identifier
  shown in these operations was shown as the GMT offset value,
  for example "GMT-4:00"
  

Problem conclusion

• A fix is available in ClearQuest 8.0.0.1
  
  1) Hours and minutes are now correctly reflected in the
  exported query results, printed data and when using the base
  ClearCase integration.
  
  2) When using the LONG date format, the timezone identifier
  shown in these operations is the correct abbreviated
  timezone identifier based on the user's locale, instead the
  GMT offset value, e.g. "EST" instead of "GMT-4:00".
  
  3) A ClearQuest web client user's timezone ID and timezone
  offset are now available to hooks via the session variables
  "_CQ_WEB_TIMEZONE" and "_CQ_WEB_TZOFFSET".
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  CLEARQUEST WIN

• Fixed component ID

  5724G3600

Applicable component levels

• R710 PSN

     UP