SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Time zone conversion- from BST (british summer time) to EST 11gR2

DSJul 5 2011 — edited Jul 5 2011

Hi ALL
I used function FROM_TZ to convert British summer time to EST using the below query.

select FROM_TZ (TO_TIMESTAMP (TO_CHAR (sysdate - 1, 'mm/dd/yyyy hh24:mi:ss'),
                                      'mm/dd/yyyy hh24:mi:ss'
                                     ),
                'BST'
                ) at time zone 'EST5EDT'
from dual;

ORA-01882: timezone region not found
01882. 00000 -  "timezone region %s not found"
*Cause:    The specified region name was not found.
*Action:   Please contact Oracle Customer Support.

Why it is not recognizing BST time zone.. or am I missing something?

This post has been answered by KPR on Jul 5 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2011

Added on Jul 5 2011

3 comments

1,633 views