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

How to improve ADO performance (3m)

Transaction was deadlocked on lock resources with another process and was chosen as the (87m)

Conditional Column calculation (2h)

SQL query to find duplicate and remove by giving some conditions (2d)

How to use a partition by in a table with a clause from another table (2d)

What is wrong with my Case statement (2d)

Exercise (2d)

Create a query to refresh multiple materialized views in serie (3d)

- Advertisement -