Hello Team.
Somebody knows the best method to update the time zones for all the users?
Like
Hello Federico,
Thank you for your question!
Unfortunately, there is no basic system setting to change the time zone for already existing system users.
You can use the SQL script for this purpose.
Please note that the DateTimeFormatId column value refers to the SysLanguage table and the TimezoneId value refers to the Code column in Timezone table so the SQL script will be the following:
UPDATE SysAdminUnit SET DateTimeFormatId = 'value from SysLanguage', TimeZoneId = 'Code column value from TimeZone table' WHERE ContactID IS NOT NULL
All you need to do is to add the proper IDs you'd like to change the values to.
For example, here is the script with values which will set Date and Time format for all users to English and timezone to GMT:
UPDATE SysAdminUnit SET DateTimeFormatId = '910eb38b-c00f-4d84-8e4a-853a62476b68', TimeZoneId = 'GMT Standard Time' WHERE ContactID IS NOT NULL
Kind regards,
Anastasiia
Hello Federico,
Thank you for your question!
Unfortunately, there is no basic system setting to change the time zone for already existing system users.
You can use the SQL script for this purpose.
Please note that the DateTimeFormatId column value refers to the SysLanguage table and the TimezoneId value refers to the Code column in Timezone table so the SQL script will be the following:
UPDATE SysAdminUnit SET DateTimeFormatId = 'value from SysLanguage', TimeZoneId = 'Code column value from TimeZone table' WHERE ContactID IS NOT NULL
All you need to do is to add the proper IDs you'd like to change the values to.
For example, here is the script with values which will set Date and Time format for all users to English and timezone to GMT:
UPDATE SysAdminUnit SET DateTimeFormatId = '910eb38b-c00f-4d84-8e4a-853a62476b68', TimeZoneId = 'GMT Standard Time' WHERE ContactID IS NOT NULL
Kind regards,
Anastasiia