Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Different time zones
We are running 8i. Does that mean we are stuck?
I have no desire to be on the bleeding edge and as of IOUG in April, the recommendation from several speakers was "do not migrate to 9i - it's not quite there yet."
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:ai45mi$l3j$1_at_lust.ihug.co.nz...
> It's exactly what the 'timestamp with local time zone' data type was
> invented for.
>
> Don't get it confused with the 'timestamp' data type, which is invariant
> during selects.
>
> And, of course, you have to be running 9i to be able to take advantage of
> it.
>
> Regards
> HJR
>
> "Chuck" <chuckh_at_softhome.net> wrote in message
> news:ai440b$11b4pp$1_at_ID-85580.news.dfncis.de...
> > Is there a way to have a sql query display a date column using the
> client's
> > local time zone instead of the time zone on the server? For example say
I
> > insert a row into a database in New York (EST) with the time of 14:00.
If
> > someone on CST selects the row I want it to show 13:00. If somone else
on
> > EST selects it I want it to say 14:00. Can this be accomplished without
> > using the new_time() function?
> >
> >
>
>
Received on Mon Jul 29 2002 - 14:48:59 CDT