Webcon BPS & Timezone settings

0

Hi Nik,

the displayed time's in BPS Portal are based on the client time zone. The attached screenshot shows the changes to the displayed time depending on the set time zone.

The time is (should be) stored in UTC in the database. You could verify this.

There's also a global parameter 'DatabaseTimeZone' in the config database.
SELECT *
FROM [BPS_Config].[dbo].[GlobalParameters]
where PRM_Name = 'DatabaseTimeZone'

I had to change this once after a we moved the database from one SQL server to another which had a different time zone setting. But I have no idea what this actually does but it had to match the time zone of the server. One effect maybe is that I receive mails send via an global action at a different time now. The difference between the original time zone and the new one is added to the original time. I need to verify this later.

Maybe there some useful information here.


Best regards,
Daniel

Hi Daniel!

Thanks for your answer.

We already verified timezone settings, everything is stored in UTC, as you said.

Our client timezone settings are correct, time displayed in UI is still 2 hours ahead.

We really don't want to mess with any setting in database, so it is unclear for us, what should try out next to solve this issue.

Best regards, Nik