We are having a problem with the display of date/times in Report Studio. Randomly, Cognos is adding one hour to the time of a date/time retrieved from the database. This seems to occur during the time of March 8^th, when Day Light Savings turned on for us.

• This occurs randomly, one row in a report will display with the incorrect hour, the next row will be correct.
• If we use the _hour function on the column, the result is the correct hour as in the database.
• Applying various report formats to the column does not change the result.
• Generating the SQL from the report, and running it directly in the database produces accurate results for all rows.
• This occurs on a bunch of different date columns, not just one.
• There is no underlying formatting or calculations defined in the package for these dates.
• The issue persists in Query Studio

 This is an example of data:

 Row1:

   Database              3/8/2020 2:02:03 AM

   Cognos Report     3/8/2020 3:02:03 AM   (Incorrect, one hour added)

   _hour function = 2

Row2:

   Database              3/8/2020 3:02:10 AM

   Cognos Report     3/8/2020 3:02:10 AM     (Correct Hour)

Is this anything you've run into before? Any ideas? We are on 11.1.R2.