Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Time zones trying to synchronize application
in my experience, the timezone associated with datetime data is
governed by the timezone that the oracle _listener_ was started
in, the server and the client do not affect it.
actual datetime storage in the server in timezone-neutral, but the data is formatted for the timezone of the listener when selected.
we consciously start a listener for each timezone that will be writing data to a database. the tnsnames.ora for a particular client is then written to connect to the correct port so that datetime is formatted correctly.
I hope that helps...
In article <36BF4B3E.599354BB_at_future-horizons.com>,
Anil Bharadwa <anil_at_future-horizons.com> wrote:
> I am trying to retrieve the time zone of the server in order to
> synchronize client machines before posting transactions since they are
> connecting from different timezones with mismatched system clocks. I am
> wondering if the NLS_DATE FORMAT can incorporate the servers time zone.
> Thank you for any help you may offer for this problem
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 10 1999 - 12:16:58 CST