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

I think you might look at the SESSIONTIMEZONE:  

Select SessionTimeZone from dual;

Gives at my place +02:00, meaning that I'm 2 hours befor UTC.  

For a complete and exhaustive (.) explanation of these matters please read :'Oracle pl/sql programming 3rd ed' by Steven Feuerstein  

Greetings,  

Rob Zijlstra

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Loughmiller, Greg
Sent: donderdag 28 juli 2005 20:29
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