Re: Different time zones

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 30 Jul 2002 05:40:35 +1000
Message-ID: <ai45mi$l3j$1@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:40:35 CDT