Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Timezones Help Required..Pls

Timezones Help Required..Pls

From: Roy Munson <mtproc_at_yahoo.co.uk>
Date: 29 Nov 2004 03:59:41 -0800
Message-ID: <853055e7.0411290359.47276177@posting.google.com>


Hi,

Have clients who may be based in different timzones to the database server. The clients need to do their own ad-hoc SQL queries. Is it possible to set the clients timezone when they connect via a SQL Plus session so that times retrieved are shown not as stored but as their timezone?

Really need help ASAP on this if possible.

Regards Received on Mon Nov 29 2004 - 05:59:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US