Another DST Update

Just a quick update to the DST impact on SQL Server Compact Edition before rushing in for routine work.

As mentioned in my earlier blog - GetDate() calls are the to watch for here also.

In addition time reported in transaction log could also be incorrect.

For that matter any application relaying directly on client machine time for validation also need to made ready for DST.

Refer to:

FIX: U.S. daylight saving time changes in 2007 do not occur on the correct day on Windows CE 5.0-based devices

https://support.microsoft.com/default.aspx?scid=KB;%5bLN%5d;921095

and

How to update daylight saving time for the United States, Canada, and Mexico in 2007 on Windows CE-based devices

https://support.microsoft.com/default.aspx?scid=KB;%5bLN%5d;923027