Re: How to get timezone in 9i

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 18 Feb 2005 07:50:19 -0700
Message-ID: <421600AB.5040400@centrexcc.com>

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
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Regards

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

Received on Fri Feb 18 2005 - 09:56:33 CST