Re: How to get timezone in 9i
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- Date: Fri, 18 Feb 2005 10:16:32 -0500
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@xxxxxxxxxxxxx> wrote:
> SQL> select dbtimezone from dual;
> DBTIME
> ------
> -07:00
--
//www.freelists.org/webpage/oracle-l
Other related posts:
