Cognos Analytics

Hi!

I recognized a timezone issue in CAoC. In my PostgreSQL database, my most recent record in a table shows a timestamp of:

2022-03-17 01:58:00.000 +0100

If I do a "show timezone" statement in the database, it shows: Europe/Berlin

Now, if I look at the same table in a Cognos data module, the most recent record shows the timestamp:

2022-03-16T19:58:00‬‪

If I open the Cognos settings, regional options, timezone is set as: (GMT+1:00) Germany Time

Now I am wondering: Why is there a 7h difference?

Are there any other hidden timezone settings that need to be changed?

The computer itself is in Berlin/Europe timezone, too.

My first guess was that Cognos is hosted somewhere in GMT-6.

Thanks for your help!

We saw the exact issue in our project!! Pls advise on how to proceed, help is needed!