Re: Problem with Oracle Timezones

Tejaswini wrote:

> Hi,
>
> I am getting some problems while using oracle time zones. The query I
> am
> using is as:
>
> select FROM_TZ(CAST(TO_DATE('10/2/2005 10:22:30','DD/MM/YYYY HH:MI:SS
> AM')
> AS TIMESTAMP), 'GMT') at time zone 'Europe/Kiev' AS New_Time from dual;
>
> It gives me error as :
> ORA-01882: timezone region %s not found
>
> I checked that v$timezone_names contains entry for Europe/Kiev.
>
> The query works fine for some values but not for all values from
> v$timezone_names.
>
> What can be the reason for this error? Do I need to do any other
> setting?
>
> Thanks in advance.
> Tejaswini.

SQL*Plus: Release 10.1.0.4.0 - Production on Sun Apr 17 10:17:26 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> select FROM_TZ(CAST(TO_DATE('10/2/2005 10:22:30','DD/MM/YYYY HH:MI:SS

   2 AM')
   3 AS TIMESTAMP), 'GMT') at time zone 'Europe/Kiev' AS New_Time from dual;

NEW_TIME

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)