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