Tweet
[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.
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.
Comment