Sunday, March 25, 2012

Daylight Savings Time Change in 2007

Is there a patch available for SQL Server 2000 to address the 2007 change in
daylight savings time?
Thank you very much in advance for your help.
Thanks,
SallySally wrote:
> Is there a patch available for SQL Server 2000 to address the 2007 change
in
> daylight savings time?
> Thank you very much in advance for your help.
> Thanks,
> Sally
SQL Server takes the current date and time from the OS. For details
see:
http://www.microsoft.com/windows/timezone/dst2007.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

No comments:

Post a Comment