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 > -- > //www.freelists.org/webpage/oracle-l > -- Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l