Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TimeZone in Oracle 8i...

Re: TimeZone in Oracle 8i...

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Thu, 15 Nov 2007 09:19:41 -0800 (PST)
Message-ID: <423f2676-93c6-4a57-a7bd-a7c54f284621@c30g2000hsa.googlegroups.com>


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

carlos_at_db01.xxxxxx> SELECT SESSIONTIMEZONE FROM DUAL;

SESSIONTIMEZONE



+01:00

carlos_at_db01.xxxxxx>

HTH. Cheers.

Carlos. Received on Thu Nov 15 2007 - 11:19:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US