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