Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to get timezone in 9i

Re: How to get timezone in 9i

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Fri, 18 Feb 2005 11:17:42 -0500
Message-ID: <f09dd628050218081750e49faa@mail.gmail.com>


but this will not handle timezone switch , say for example when we change from EST to EDT or vice versa.

On Fri, 18 Feb 2005 16:42:34 +0100, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> >I need to get international time zones in 3 letter format, something
> >like EST,CDT ....etc.
> ALTER DATABASE SET TIME_ZONE = 'EST';

 Then when you select DBTIMEZONE you get the correct format.
> Notice that you cannot alter the database if it stores tables with TIMESTAMP WITH LOCAL TIME ZONE columns.
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US