Re: How to get timezone in 9i

From: Sami Seerangan <dba.orcl@xxxxxxxxx>
To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
Date: Fri, 18 Feb 2005 10:09:07 -0500

Thanks for your response.
I need to get international time zones in 3 letter format, something
like EST,CDT ....etc.


On Fri, 18 Feb 2005 15:40:01 +0100, Christian Antognini
<Christian.Antognini@xxxxxxxxxxxx> wrote:
> 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?
> 
> SQL> select dbtimezone from dual;
> 
> DBTIME
> ------
> +01:00
> 
> HTH
> Chris
--
http://www.freelists.org/webpage/oracle-l

References:

RE: How to get timezone in 9i
From: Christian Antognini

Re: How to get timezone in 9i

Other related posts: