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. |
What version are you using? AFAIK, v12 has introduced the new data type TIMESTAMP WITH TIME ZONE and the new special value CURRENT UTC TIMESTAMP exactly for such use cases. Actually it's all in 11. We are planning to upgrade to 12 this year.
(24 Feb '12, 07:44)
Zote
FYI,
(27 Feb '12, 11:01)
Graham Hurst
Replies hidden
Now I'm somewhat puzzled what exactly has been improved with v12:
(27 Feb '12, 12:24)
Volker Barth
1
Before version 12, one always needed to know what timezone was used for values in timestamp columns. All that
(27 Feb '12, 16:06)
Graham Hurst
|
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'; |