Daylight Saving Time

Question

Daylight Saving Time

Jimmpy Gill

Say Hey Kid

Points: 670
More actions
December 27, 2006 at 10:46 am

#193557

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

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

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

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://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=331667

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

Greg

SQLBill SSC Guru Points: 51440 More actions · Answer 2

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

-SQLBill

Donatello SSC Eights! Points: 853 More actions · Answer 3

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

SQLBill SSC Guru Points: 51440 More actions · Answer 4

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

MohammedU SSCoach Points: 19644 More actions · Answer 5

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

Mark Harr SSCrazy Eights Points: 9921 More actions · Answer 6

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://www.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

SQLBill SSC Guru Points: 51440 More actions · Answer 7

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