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 -> Re: Timezones Help Required..Pls

Re: Timezones Help Required..Pls

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 30 Nov 2004 05:20:28 +1100
Message-ID: <41ab685a$0$9113$afc38c87@news.optusnet.com.au>


Roy Munson wrote:
> 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

An Oracle version would help. If it is 9i or better, then the TIMESTAMP WITH LOCAL TIME ZONE data type will do what I think you are after.

Regards
HJR Received on Mon Nov 29 2004 - 12:20:28 CST

Original text of this message

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