Ask Experts Questions for FREE Help!
 

Free Answers in 3 Easy Steps

Register Now
3 Steps
 


Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.
  View Answers    Answer this question    Ask a question  
 

VBNomad
Jul 25, 2006, 01:37 PM
With the standard beginning and end dates of daylight savings time changing next year, will any of the MS database products be affected? My site is still using Access 98, as well as 2000, SQL/Server 2000 and Oracle 10. My concern is really for the functions packaged with those database. Will they know when the new daylight savings time starts and stops, or is that data hard coded deep inside the code? (No doubt it should not be, but that doesn't mean that's the way it is.)

CaptainForest
Jul 25, 2006, 01:45 PM
Most likely Microsoft will be releasing some new type of upgrade patch.

And if not, you could always change it manually.

VBNomad
Jul 26, 2006, 08:07 AM
Hopefully XP and Windows Server will be patched to handle the basic time change. What I was more interested in was the intrinsic functions within the database packages. If they look to the operating system for time data, then it's probably going to be OK. If the info is hardcoded into the db code, then the result of a date calculation that ends up on the other side of the new DST may be calculated incorrectly. I'm trying to get some expert opinions from people who know these databases before I tell my client they may have a problem.