From oracle-l-bounce@freelists.org Thu Jul 28 13:31:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6SIVUjY001574 for ; Thu, 28 Jul 2005 13:31:30 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6SIVPIP001559 for ; Thu, 28 Jul 2005 13:31:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 92FB61D9385; Thu, 28 Jul 2005 13:31:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22854-01; Thu, 28 Jul 2005 13:31:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 094491D93DE; Thu, 28 Jul 2005 13:31:18 -0500 (EST) Message-ID: <5164A49467308C45AD50661F8CFDC3432508A3D0@s30342g004004.wdc.cingular.net> To: "'Oracle-L@freelists.org'" Subject: databases on same server with different timezones... Date: Thu, 28 Jul 2005 14:28:53 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C593A2.34DF94A0" From: "Loughmiller, Greg" X-archive-position: 23011 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: greg.loughmiller@cingular.com Precedence: normal Reply-To: greg.loughmiller@cingular.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.8 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C593A2.34DF94A0 Content-Type: text/plain 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 ------_=_NextPart_001_01C593A2.34DF94A0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

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

------_=_NextPart_001_01C593A2.34DF94A0-- -- http://www.freelists.org/webpage/oracle-l