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 | 0 Comments | 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. Follow the link to How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

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

Randomly Assign to Group (6 Replies)

Conditional Join creating duplicates (6 Replies)

T-SQL Code Help (12 Replies)

Database keeps growing by 5 gigs, what should I do (0 Replies)

Comparing Rows in same table (1 Reply)

T-test (2 Replies)

Return error of a timeouted server (2 Replies)

Retrieving Current and Prior Year Total on one row (1 Reply)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -