IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    PM08377

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-23

  • Closed date

    2011-12-16

  • Last modified date

    2011-12-16

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
16 December 2011