It's not a timezone switch. You are still in the same timezone
but switching from daylight saving to none daylight saving. The
OS handles such a switch.
On Fri, 18 Feb 2005 11:17:42 -0500, Sami Seerangan <dba.orcl_at_gmail.com> wrote:
> 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
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 18 2005 - 16:00:56 CST
