Re: How to get timezone in 9i
- From: Richard Ji <richard.c.ji@xxxxxxxxx>
- To: dba.orcl@xxxxxxxxx
- Date: Fri, 18 Feb 2005 14:01:19 -0500
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@xxxxxxxxx> 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@xxxxxxxxxxxx> 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.
> >
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
