Hi Sami >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? Mhmm... if you are looking for the db timezone just select it... SQL> select dbtimezone from dual; DBTIME ------ +01:00 HTH Chris -- //www.freelists.org/webpage/oracle-l