RE: How to get timezone in 9i

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 18 Feb 2005 15:40:01 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A01E6B6B6@MSXVS02.trivadis.com>

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

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

Received on Fri Feb 18 2005 - 09:43:03 CST