Re: Different time zones

"Chuck" <chuckh_at_softhome.net> wrote in message news:ai467c$11fqr1$1_at_ID-85580.news.dfncis.de...
> We are running 8i. Does that mean we are stuck?
>

I guess so.

> 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."
>

I disagree with that. I wouldn't call 9i 'bleeding edge', and I think it as robust as at least 8.1.6.

Regards
HJR
>
> "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 Tue Jul 30 2002 - 03:33:14 CDT