Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: "Tejaswini" <tejaswini.dixit@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Problem with Oracle Timezones
Date: 17 Apr 2005 04:25:10 -0700
Organization: http://groups.google.com
Lines: 24
Message-ID: <1113737110.301348.208030@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 202.54.11.72
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1113737125 4125 127.0.0.1 (17 Apr 2005 11:25:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 17 Apr 2005 11:25:25 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=202.54.11.72;
   posting-account=Xz5hdA0AAACL3NtPYWSe0pCfnB6LOtbt
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:240597

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.