Timezone per server/database

[Former Member]

We host database for some online applications and some of our new customers are located in another timezone.

Since we have all database running in just one box, is that possible to configure timezone in database/db server, this way sa will not use OS timezone.

[former_SQLA_member1694901]

In the option "PUBLIC.time_zone" with "Simulated Time Zones" seems to do this in the current version (Anywhere 17)

CREATE TIME ZONE NewSouthWales OFFSET '10:00'
STARTING 'Oct/Sun>=1' AT '2:00'
ENDING 'Apr/Sun>=1' AT '2:00';

SET OPTION PUBLIC.time_zone='NewSouthWales';