Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Other Databases (https://www.askmehelpdesk.com/forumdisplay.php?f=444)
-   -   Daylight Savings changes & MS Dbs (https://www.askmehelpdesk.com/showthread.php?t=30194)

  • Jul 25, 2006, 01:37 PM
    VBNomad
    Daylight Savings changes & MS Dbs
    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.)
  • Jul 25, 2006, 01:45 PM
    CaptainForest
    Most likely Microsoft will be releasing some new type of upgrade patch.

    And if not, you could always change it manually.
  • Jul 26, 2006, 08:07 AM
    VBNomad
    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.

  • All times are GMT -7. The time now is 03:31 PM.