Ask Experts Questions for FREE Help !
Ask
    VBNomad's Avatar
    VBNomad Posts: 65, Reputation: 7
    Junior Member
    		  
    #1

    Jul 25, 2006, 01:37 PM
    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.)
    CaptainForest's Avatar
    CaptainForest Posts: 3,645, Reputation: 393
    Ultra Member
    		  
    #2

    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's Avatar
    VBNomad Posts: 65, Reputation: 7
    Junior Member
    		  
    #3

    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Savings deposit [ 3 Answers ]

You deposited $1,000 in a savings account that pays 8 percent interest, compounded quarterly, planning to use it to finish your last year in college. Eighteen months later, you decide to go to the Rocky Mountains to become a ski instructor rather than continue in school, so you close out your...

How Much Savings for Retirement [ 4 Answers ]

A friend is planning on retiring by 50. She asked me how much money she should have in her retirement account in order to retirement. I gave her two scenarios: (1) with a retirement pension and (2) with no pension. So, if she has a pension, I told her she needed enough in her retirement...

Savings? [ 6 Answers ]

Hello all. I'm new here and hope to get some replies. I'm thinking of buying a co-op in NY city. I make about 1000 a week and pay 1000 a mo. In rent, my share, Anyway, what would the cost savings be if any should I buy this apt. The mortgage would be about 1600 a mo. Plus 1000 for fees and taxes...

Daylight time new dates [ 8 Answers ]

I was on the NBS site to set my watch. The standard time notice reminded me we will be on daylight time longer starting this year. I am sure the old Mac I was using has no way of knowing it. Where is that information stored, and how do you change it? Could be a bigger mess than Y2K turned out...

Medical Savings Accounts [ 1 Answers ]

I would like to know if MSA's are worth considering. I am self employed with a wife and 2 children living in NYC. Thanks

View more questions Search