How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007

By Bill Graziano on 5 March 2007 | Tags: General


"In August 2005, the U. S. Congress passed the Energy Policy Act. This act changes both the start date and the end date of daylight saving time (DST). When this act goes into effect in 2007, DST will start three weeks earlier and will end one week later than when it traditionally started and ended. Specifically, DST will start at 2:00 A.M. on the second Sunday in March and will end at 2:00 A.M. on the first Sunday in November." The summary is that you need to patch the operating system and Notification Services if you use it. The link has a fair amount of detail on how SQL Server deals with times.

Link: How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007


Related Articles

Visual Studio 2005 Team Edition for Database Professionals (5 June 2006)

SQL Server/Visual Studio/BizTalk Connected Systems Developer Competition (30 May 2005)

Microsoft Developer Survey (9 December 2004)

MS Best Practices Analyzer Released (26 May 2004)

Appropriate Uses of MSDE (11 October 2002)

MSDE Information and Requirements (25 March 2002)

MDAC in Motion (26 November 2001)

Oracle vs. SQL Server - An Issue Of Complexity (10 June 2001)

Other Recent Forum Posts

SQL Update Union (17h)

Use sp_Send_DBMail with Variable (1d)

Is there a function in SQL that does the same as the Excel forecast.ets function? (2d)

Case statement within and (3d)

SUM values based on values of another column (3d)

SSIS Error The type of the value (DBNull) being assigned to variable "User::FileName" differs from the current variable type (String) (3d)

Conversion failed when converting date and/or time from character string (4d)

Split String Update Query (4d)

- Advertisement -