Re: How to get timezone in 9i

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.
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: