ORA-01882: TIMEZONE REGION NOT FOUND |Oracle Error

0 Flares Twitter 0 Facebook 0 Google+ 0 LinkedIn 0 Buffer 0 Email -- Filament.io 0 Flares ×

ORA-01882: TIMEZONE REGION NOT FOUND. This error occurs when timezone region string not found.The specified region name was not found.There are a number of time zone constants defined in oracle to use.See the last part of this post to know hoe to get the defined time zone constants in your oracle database.
Here is an example and a solution for the problem:

SQL> select EXTRACT(TIMEZONE_REGION FROM TIMESTAMP '01-01-08 11:53:42 PM +05:30')TIMEZONE_REGION from dual;
select EXTRACT(TIMEZONE_REGION FROM TIMESTAMP '01-01-08 11:53:42 PM +05:30')TIMEZONE_REGION from dual
ORA-01882: timezone region  not found

SQL>

The timezone region string was missing from the above query.
Rewrite the query as follows

SQL> select EXTRACT(TIMEZONE_REGION FROM TIMESTAMP '01-01-08 11:53:42 Pacific/Midway')TIMEZONE_REGION from dual;
TIMEZONE_REGION
Pacific/Midway

SQL>

Now it works!
Also to see the Time Zones try the following query:

SQL> SELECT * from V$TIMEZONE_NAMES;

It will display a number of entries like
TZNAME—————Etc/GMT-6Etc/GMT-7Europe/RigaEurope/SarajevoEurope/Simferopol…………etc

Also Read,

Technorati Tags:
, , ,

0 Flares Twitter 0 Facebook 0 Google+ 0 LinkedIn 0 Buffer 0 Email -- Filament.io 0 Flares ×

1 thought on “ORA-01882: TIMEZONE REGION NOT FOUND |Oracle Error

  1. Pingback: Oracle timestamp format milliseconds| Oracle Date format | SQL and PLSQL

Leave a Reply

Your email address will not be published. Required fields are marked *

Paged comment generated by AJAX Comment Page