Skip to Main Content

Oracle Database Discussions

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!

Difference between GB and Europe/London Time Zone Region

RichDBAAug 3 2012 — edited Aug 3 2012
Is there any difference between the GB and Europe/London Time Zone Regions?

I've checked through the documentation and I can't find anything in there. I've also queried the V$TIMEZONE_NAMES view and they show the same abbreviations, so I'm assuming that they're the same, and it's just a case a being as specific as you want.
ORA11GR1> SELECT * FROM v$timezone_names WHERE tzname IN ('GB', 'Europe/London');

TZNAME                                                           TZABBREV
---------------------------------------------------------------- ----------------------------------------------------------------
Europe/London                                                    LMT
Europe/London                                                    GMT
Europe/London                                                    BST
Europe/London                                                    BDST
GB                                                               LMT
GB                                                               GMT
GB                                                               BST
GB                                                               BDST
If anyone can point me in the direction of any docs/articles that might be able to shed some light on it I'd appreciate it, if not then I think I'll settle for Europe/London and I'm in England.

Cheers
Rich

Edited by: RichDBA on 03-Aug-2012 04:01
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2012
Added on Aug 3 2012
1 comment
683 views