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.
asked 24 Feb '12, 07:24
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.