Monday Oct 31, 2011

Are you still on Daylight Savings Time?

Central Europe and many other countries switched back from Daylight Savings Time to regular time on this Sunday's night. But others don't. Thanks to a "wise" decision in 2006 the US will switch back to regular time in one week. And another "wise" man has decided that there's no need for Russia to switch back to regular time (see the last paragraph on "DST" in this linked Wikipedia article) - so Russia will stay forever on DST being one hour ahead ;-) Samoa will simply jump from the end of the time zone puzzle now heading it end of this year - so there will no December 28th this year in Samoa (I wonder what will happen if they switch back one day?).

And if you wonder why your new Apple iPhone 4S drains the battery pretty quick the algorithm polling the time zone server in the internet every second might be the reason Why ... ;-)

Now you might ask yourself:
Why am I writing about all this stuff?

Simple reason: As you might know the database has time zone definitions in $ORACLE_HOME/oracore/zoneinfo since Oracle Database 9.2. Good news for everybody who'll upgrade from Oracle Database Patch Set 11.2.0.2 to 11.2.0.3 - both contain TZ V14 so there's no time zone adjustment post patch upgrade necessary. But the newest available Time Zone files is TZ V17.

One day a customer did complain to me about the misleading MOS notes calling it a "Time Zone Spaghetti". Even though the note situation has been cleaned up  (at least a bit) and MOS Note:977512.1 contains the one-and-only script to change the settings you may watch a little 6 minute video about the background on DST published by C.G.P. Grey:


By the way, this is an overview on Time Zone Version per Oracle Database release:

Oracle Database Release

Default Time Zone Version

9.2.0.x

DST V1

10.1.0.x

DST V2

10.2.0.1 – 10.2.0.2

DST V3

10.2.0.3 – 10.2.0.5

DST V4

11.1.0.6 – 11.1.0.7

DST V4

11.2.0.1

DST V11

11.2.0.2 – 11.2.0.3

DST V14

About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers