View Single Post
  #1 (permalink)  
Old February 26th, 2007, 18:54
mldeuel mldeuel is offline
Junior Member
 
Join Date: Sep 2006
Posts: 3
Thanks: 1
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
mldeuel is on a distinguished road
Lightbulb [SOLVED] Clarification on the '07 DST changes to the Property Files for v4.5 and belo

FYI - Below is the question I had for Oracle regarding the updates that we needed for the Property Files (OTM glog.timezone.properties file) and they're answer in return:

In the documentation provided on the Oracle Metalink site it states that the time zones should take the format of:

glog.timezone.<time zone ID>=<GMT offset>

-but it doesn't clarify if the 'GMT offset' that we enter is GMT offset for standard or day light savings. For example, for NY would we put:

glog.timezone.America/New_York=-4,MARCH,2,SUNDAY,2,NOVEMBER,1,SUNDAY,2,1
- for DST (-4 being the DST offset to GMT)
or:
glog.timezone.America/New_York=-5,MARCH,2,SUNDAY,2,NOVEMBER,1,SUNDAY,2,1
- for standard (-5 being the standard offset to GMT)?

*2nd Question: We are updating to 5.0 - but our production is still 4.0 - but for those who still have 4.5 or below - will they have to change to property files in the Fall
again?

ORACLES ANSWER:

Q1 - Answer: GMT offset is the standard time, to be for NY as bellow:

glog.timezone.America/New_York=-5,MARCH,2,SUNDAY,2,NOVEMBER,1,SUNDAY,2,1

Q2- Answer: For versions 4.5 and below users will have to **manually** override the Daylight Savings Rules with the OTM glog.timezone.properties file.

Which means that you will be in need to change the property files in the Fall again.