Problem with Oracle Timezones

From: Tejaswini <tejaswini.dixit_at_gmail.com>
Date: 17 Apr 2005 04:25:10 -0700
Message-ID: <1113737110.301348.208030@o13g2000cwo.googlegroups.com>

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. Received on Sun Apr 17 2005 - 06:25:10 CDT