RE: How to get timezone in 9i
- From: "Hollis, Les" <Les.Hollis@xxxxxx>
- To: <dba.orcl@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Feb 2005 08:45:18 -0600
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
Other related posts:
