RE: How to get timezone in 9i

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Fri, 18 Feb 2005 08:45:18 -0600
Message-ID: <FCC960FDB92F5E469A02464FF72872F4041EA4D3@pscdalpexch50.perotsystems.net>

Select sessiontimezone from dual;

SQL> select sessiontimezone from dual;

SESSIONTIMEZONE

---
-05:00

SQL>
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 18 2005 - 09:47:54 CST