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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to get timezone in 9i

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

Original text of this message

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