Re: Different time zones

From: Yong Huang <yong321_at_yahoo.com>
Date: 1 Aug 2002 14:05:47 -0700
Message-ID: <b3cb12d6.0208011305.4fb595@posting.google.com>

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

Can you take a look at the NEW_TIME function in SQL Reference?

Also, select sessiontimezone from dual gives the timezone if you need it in a script. This sessiontimezone function (?) is not documented anywhere except shown in v$reserved_words.

Yong Huang Received on Thu Aug 01 2002 - 16:05:47 CDT