RE: databases on same server with different timezones...

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?  

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Loughmiller, Greg
Sent: Thursday, July 28, 2005 1: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  

--
http://www.freelists.org/webpage/oracle-l