daylight saving time (DST)

Hi,

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

You don't need to. Sql Server gets its dates and times from the operating system.

|||

But I am facing some problems.......

Is there have any alternative for getdate() and dateDiff() function for this issue?

|||

Please excuse me. I wasn't thinking. Look at the following:How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007

|||

Yes, I have already gone through this link. But I am not cleared about the issue. I am using windows 2000 and 2003 OS.

Can Any body please tell me that what should be done from my end to make my sql server compatible to this DST Issue?

|||

Hi,

Actually, you don't need to anything. Just set the time zone of your operating system to the correct zone. If in this time zone, there is Daylight Saving Time, it will show up in the window.

You will need to apply the patches from that KB to have the correct start date of DST.