6.3 Patch 20 - Issues with years prior to 2007Eric, If you are using SQL server, the attached SQL script may help to resolve some of the issues with historical reporting.
It will create a function to convert epoch time values to local datetime, using the "old" rules for dates prior to 2007 (DST ranges from 1st Sunday in April to Last Sunday in October) and the "new" rules for dates after 2007 (DST ranges from 2nd Sunday in March to 1st Sunday in November). The function was written for the U.S. Central time zone, using a 5 hour (18,000 second) offset from GMT during DST, and a 6-hour (21,600 second) offset during standard time. For other U.S. time zones, simply modify the offset seconds values in the last section of the script. HTH, Thomas ----- Original Message ----- From: Eric Cleereman (IT) Newsgroups: gmane.comp.crm.arsystem.general To: [email protected] Sent: Wednesday, February 21, 2007 15:06 Subject: Re: 6.3 Patch 20 - Issues with years prior to 2007 ** Peter, Tickets from March 12th - April 2nd 2006 and from October 29th - November 5th of 2006 all seem to be off by an hour. All other tickets outside of those ranges seem to be accurate. Frederick, Each of the patches you asked about was applied prior to the Remedy patches being applied. Eric -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W Sent: Wednesday, February 21, 2007 3:38 PM To: [email protected] Subject: Re: 6.3 Patch 20 - Issues with years prior to 2007 ** Just to check ... On the AIX box you have - The AIX DST patches applied - The updated Java - The ARS server patch On the Windows box you have - The Microsoft DST patches applied - The updated Java - The ARS Mid-Tier patch -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Lammey, Peter A. Sent: Wednesday, February 21, 2007 3:26 PM To: [email protected] Subject: Re: 6.3 Patch 20 - Issues with years prior to 2007 ** Does this mean that for your saved tickets that were created between March 11th 2006 and April 2nd 2006 that the Create Time for the tickets are now off by one hour after you installed Patch 20? Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cleereman (IT) Sent: Wednesday, February 21, 2007 3:17 PM To: [email protected] Subject: 6.3 Patch 20 - Issues with years prior to 2007 ** Hi All, I'm running version 6.3 of ARServer under Oracle 9 on AIX, and version 6.3 of Mid-Tier on Windows 2000 in my development environment. I've just installed Patch 20 for both, and am in the process of doing some preliminary testing. Remedy seems to be applying the revised schedule for 2007 for earlier years as well. For example, it seems to be seeing March 20th 2007 as Eastern Daylight Time (EDT), which is correct. But it seems to see March 20th 2006 as EDT as well. In 2006 EDT did not go into effect until April 2nd, so it should see that date as Eastern Standard Time (EDT). This is an issue for us, as we do a lot of historical reporting. Has anyone else running 6.3 Patch 20 (or 7.1 Patch 1) noticed any problems with Daylight Saving time calculations for 2006 or prior years? Eric Cleereman __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
convert_epoch_to_date.sql
Description: Binary data
