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