Select sessiontimezone from dual; SQL> select sessiontimezone from dual; SESSIONTIMEZONE ------------------------------------------------------------------------ --- -05:00 SQL> -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sami Seerangan Sent: Friday, February 18, 2005 8:35 AM To: oracle-l Subject: How to get timezone in 9i 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 -- //www.freelists.org/webpage/oracle-l