Re: Handling multiple timezones

In article <6k8go9$3b4_at_dfw-ixnews4.ix.netcom.com>,   wade_warrens_at_rmthis.acm.org wrote:
> There must be some folks out there who aggregate (replicate)
> local London, New York, and Tokyo tables to a corp HQ.
> How do you keep track of the different "real" times involved.
>
> Also, crossposted to Oracle -- how does Oracle do it?
>
> thanks,
> --wade

in my experience (and this is just from observation, I can't point to a page in a manual that says this):

the timezone in oracle is determined by the timezone of the listener that you connect to. we have databases that house data from each of the four US contiguous timezones, so we simply startup four listeners (one for each timezone) on four wellknown ports. TNS entries for a city in PST8PDT are written so that the connection is made to the PST8PDT listener.

as I said, this is just my observations... in trying to figure it out, we experimented with different variations of TZ set for the server and for the client to no effect. setting TZ before starting the listener is the only thing that has worked for me...

• mark

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 26 1998 - 11:51:24 CDT