| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: databases on same server with different timezones...
What about setting the DB's individual time zones?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Loughmiller, Greg
Sent: Thursday, July 28, 2005 12:29 PM
To: 'Oracle-L_at_freelists.org'
Subject: databases on same server with different timezones...
Curious to see if anyone has a server, with multiple databases running where each database has a different TZ requirement(Pacific, Mountain, Central, and Eastern). And all databases on the server would use the same Unix acct (aka oracle).
>From what I can gather, Oracle uses the "gettimeofday" call to satisfy the request for a sysdate call. Thus, one would need to set the OS TimeZone appropriately since the DB would obtain the date/time from the OS... While I run thru the manual and metalink; I thought I would see if anyone on the list has had this experience......
Thanks
Greg
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 28 2005 - 14:03:49 CDT
 |
 |