Re: TimeZone in Oracle 8i...

From: <fitzjarrell_at_cox.net>
Date: Thu, 15 Nov 2007 10:42:59 -0800 (PST)
Message-ID: <1ccfa995-f3c4-4de2-86be-547d1c2b692e@w34g2000hsg.googlegroups.com>

On Nov 15, 11:19 am, Carlos <miotromailcar..._at_netscape.net> wrote:
> On 15 nov, 16:54, ngv.balakris..._at_gmail.com wrote:
>
> > Can you guys please help me how to know the Timezone(EST/EDT) in
> > oracle 8i.
>
> > Thanks in advance...
> > Baalu.
>
> I don't have an 8i at hand.
>
> but in 9i/10g:.
>
> car..._at_db01.xxxxxx> SELECT SESSIONTIMEZONE FROM DUAL;
>
> SESSIONTIMEZONE
> ------------------------------------------------------
> +01:00
>
> car..._at_db01.xxxxxx>
>
> HTH.
>
> Cheers.
>
> Carlos.

That works for 8.1.7.4 as well.

David Fitzjarrell Received on Thu Nov 15 2007 - 12:42:59 CST