So SQL doesn’t escape the dreaded DST2007!!!
Starting in the spring of 2007, daylight saving time (DST) start dates and end dates for the United States will change to comply with the Energy Policy Act of 2005. DST dates in the United States will start three weeks earlier (2:00 A.M. on the second Sunday in March) and will end one week later (2:00 A.M. on the first Sunday in November).
The update that this article describes modifies the time zone data for SQL Server Notification Services to account for the United States DST change. This article applies to the following versions of Microsoft SQL Server Notification Services:
- Microsoft SQL Server 2000 Notification Services 2.0
- Microsoft SQL Server 2000 Notification Services 2.0 Service Pack 1 (SP1)
- Microsoft SQL Server 2005 Notification Services
- Microsoft SQL Server 2005 Notification Services Service Pack 1 (SP1)
- Microsoft SQL Server 2005 Notification Services Service Pack 2 (SP2)