Post reply

Daylight Saving Time

  • December 27, 2006 at 10:46 am

    #193557

    Is there any hotfix available for SQL 2000 on DST?  Thanks

  • December 27, 2006 at 10:56 am

    #680136

    If you're referring to the change in U.S. DST in 2007, SQL Server doesn't appear to need a fix.  See this editorial: http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=331667

    Windows, however needs a patch: http://support.microsoft.com/kb/914387/en-us

    Greg

    Greg

  • December 27, 2006 at 10:56 am

    #680135

    Why would it need it? SQL Server gets its time from the server.

    -SQLBill

  • January 9, 2007 at 12:01 pm

    #682134

    What about the datediff type functions? The differences between times will change when the period of daylight saving time changes.

  • January 9, 2007 at 12:43 pm

    #682153

    What's the difference from the way it used to be? DATEDIFF never took care of DST. Remember, not everyone or every country uses Daylight Savings Time. For example: Arizona never changes. So how would you program DATEDIFF to know if DST is in effect?

    -SQLBill

  • January 9, 2007 at 12:44 pm

    #682154

    Datediff function provides the difference between the two dates so what is the relation with DST?

    As mentioned before sql time is system time there no other serperate clock for sql.

     

    MohammedU
    Microsoft SQL Server MVP

  • January 9, 2007 at 12:56 pm

    #682163

    Datediff also calculates difference in hours (or minutes or seconds).  But the answer is, as stated by SQLBill, DateDiff never did account for DST changes before.  If you need that, you should have been using UTC datetime, not local time.  See http://qa.sqlservercentral.com/columnists/awarren/2779.asp

    And note, there is no DST fix for Windows 2000, only XP and Server 2003 (Vista and Longhorn already have the new DST accounted for).  So if you're still running SQL Server on Windows 2000, either get your OS upgraded, or plan your 2am maintenance task for March 11, April 1, October 28 and November 4 to manually adjust the server time.

    Jan 11: Updated to correct the dates (for the old DST), according to http://www.microsoft.com/windows/timezone/dst2007.mspx



    Mark

  • January 9, 2007 at 4:45 pm

    #682248

    You have to realize, as Mark pointed out, that the DST fix is ONLY so that the OS changes the time on the correct day(s). That's all it's for. Without it everyone's computer (at least everyone with DST being used) would change to and from Daylight Savings Time on the wrong days.

    -SQLBill

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply