SQL Server Performance Forum – Threads Archive

daylight saving time (DST)

What are the alternative for getdate() and datediff() function in sql server in case of DayLight Saving Time?

---

There is no alternative for GETDATE()…
SQL gets time from OS clock… Read the following article…
How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007
http://support.microsoft.com/kb/931975 http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19316
MohammedU.
Moderator
SQL-Server-Performance.com

---

]]>