Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Timezones Help Required..Pls
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