SQL server Daylight savings patch for OCtober 2012 for Australia , New South Wales

Question

we are trying to understand if there are any SQL servers instances that need to be patched as preparation for OCT 7th daylight change. Below is the link that we found which only says that 2005/2000 Notification services  need to be patched, issue here is we are not sure if this is latest document and it would cover up coming DST and all the SQL versions. Also, for future can you please advise if there an easy way we can find out if a Particular DST will impact a particular SQL server version? Thanks in advance.

http://support.microsoft.com/gp/cp_dst#SS2005NS

---

Jagi

Answer 1

Hello Jagi,

SQL Server don't have an own date time / DST logic, it uses the OS API to handle date time. So you need only to patch your Windows OS, the the SQL Server itself.

---

Olaf Helper

Blog Xing

Answer 2

Hi Olaf,

Thanks for the response. Is this new from SQL server 2008 as within the link (http://support.microsoft.com/gp/cp_dst#SS2005NS)

I can see SQL server(2005/2000) notification services need to be patched? Are these the only one's that need to be patched? Also, is there some kind of doco that  mentions SQL servers only uses OS API, I am not questioning your knowledge, official doco would help in justifying to the business.Once again really appreciate all the help.

SQL Server Notification Services

SQL Server 2005 Notification Services

• KB 974412 DST time zone update for SQL Server 2005 Notification Services and for SQL Server 2000 Notification Services

Top of Page

SQL Server 2000 Notification Services

• KB 974412 DST time zone update for SQL Server 2005 Notification Services and for SQL Server 2000 Notification Services

---

Jagi

Answer 3

Hi JagadeshS,

For all practical purpose SQL Server uses Windows OS capabilities for time information. So ground work should start from applying the required patches for DST for Widows OS.

If you have SQL Server installed and configured for automatic DST update, and the time zone computer follows the DST changes, you must take the some actions. Follow below links.

For more information, refer to Daylight Saving Time (DST) and SQL server puzzle: http://blogs.msdn.com/b/gauravagg/archive/2007/02/26/daylight-saving-time-dst-and-sql-server-puzzle.aspx.
How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time: http://support.microsoft.com/default.aspx?scid=kb;en-us;931975&sd=rss&spid=2855.

Thanks,
Maggie

 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.