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: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Fri, 18 Feb 2005 10:16:32 -0500
Message-ID: <f09dd62805021807167c8da5ae@mail.gmail.com>


Thanks Wolfgang.Since I need 3 letters timezone(like EST,...), I tried SQL> select to_char(systimestamp,'TZD') from dual;

But this one gives null value. Do I have to set some value or init parameters,etc?  

On Fri, 18 Feb 2005 07:50:19 -0700, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> SQL> select dbtimezone from dual;
> DBTIME
> ------
> -07:00

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 18 2005 - 10:24:36 CST

Original text of this message

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