From oracle-l-bounce@freelists.org Thu Jul 28 14:50:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6SJoCas011441 for ; Thu, 28 Jul 2005 14:50:12 -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 j6SJo4IP011424 for ; Thu, 28 Jul 2005 14:50:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3D4881D8D14; Thu, 28 Jul 2005 14:49:58 -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 17068-10; Thu, 28 Jul 2005 14:49:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AE37A1D8DAA; Thu, 28 Jul 2005 14:49:57 -0500 (EST) From: "Marc Perkowitz" To: Subject: RE: databases on same server with different timezones... Date: Thu, 28 Jul 2005 14:47:55 -0500 Message-ID: <005a01c593ad$44c629f0$731511ac@MTPSYS> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005B_01C59383.5BF021F0" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <5164A49467308C45AD50661F8CFDC3432508A3D0@s30342g004004.wdc.cingular.net> X-archive-position: 23020 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mperkowitz@comcast.net Precedence: normal Reply-To: mperkowitz@comcast.net 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=-4.8 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_005B_01C59383.5BF021F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable There's a related question that I have been wondering about and have not seen any discussion on this yet. It is looking very probable that the = US will be changing the dates for Daylight Savings Time starting this fall. Since I believe Oracle also gets the DST transition dates from the OS, = then I presume we will need to apply whatever patch is needed at the OS = level, correct? =20 Is anyone aware plans by the various OS companies to have patches = available in the near future? Or perhaps instructions on how to modify parameters = or files related to this? =20 Thanks, Marc. =20 -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Loughmiller, Greg Sent: Thursday, July 28, 2005 1:29 PM To: 'Oracle-L@freelists.org' Subject: databases on same server with different timezones... =20 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).=20 >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...... =20 Thanks Greg =20 ------=_NextPart_000_005B_01C59383.5BF021F0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

There’s a related question = that I have been wondering about and have not seen any discussion on this = yet. It is looking very probable that the US<= font size=3D2 color=3Dnavy face=3DArial> will be changing the dates for Daylight Savings Time = starting this fall. Since I believe Oracle also gets the DST transition dates = from the OS, then I presume we will need to apply whatever patch is needed at the = OS level, correct?

Is anyone aware plans by the = various OS companies to have patches available in the near future? Or perhaps = instructions on how to modify parameters or files related to this?

Thanks,

Marc.

-----Original = Message-----
From: = oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Loughmiller, Greg
Sent: Thursday, July 28, = 2005 1:29 PM
To: = 'Oracle-L@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

------=_NextPart_000_005B_01C59383.5BF021F0-- -- http://www.freelists.org/webpage/oracle-l