Skip to main content

We are trying to use the timezone setting in IAM user preferences. However, it seems that it is assumed that the stored time is in UTC. I want to change this to be read as CET. Is that possible?

I mean, when I set a user’s timezone to CET, they should see the same time as is stored. Current the users are all set to UTC by default and if I change it to CET, they will not see the intended time. This is a problem, because I also want to add users in another timezone.

I would prefer not to change our whole system and existing data to store UTC dates as discussed here:
 

 

Hi Robin,

The assumption is indeed that time stored time zone is UTC. In order for the application to support multiple time zones, the data will have to be updated to UTC, and all usage of date functions will have to be re-evaluated as described in the linked topic.

Technically, it would be possible to define the ‘Base time zone’ for a domain, to set it to a time zone other than UTC. Feel free to submit an idea for this.

Note however, that using a different time zone than UTC for stored dates will reduce the portability of your application. For instance, when moving from on-prem to cloud, there’s a fair chance that the dependency on getdate() returning CET will break.