Re: How to get timezone in 9i

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: dba.orcl@xxxxxxxxx
  • Date: Fri, 18 Feb 2005 07:50:19 -0700

SQL> select dbtimezone from dual;
DBTIME
------
-07:00

Sami Seerangan wrote:
> Hi:
> 
> We have to store all the date/times in GMT format. Is there aeasy way
> to get db timezone without using java program in 9i?
> 
> Thanks in advance
> Sami
> --
> //www.freelists.org/webpage/oracle-l
> 

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l

Other related posts: