Sunday, March 25, 2012

Daylight saving time SQL

As you know the daylight saving time will change in 2007
http://www.microsoft.com/windows/timezone/dst2007.mspx
Microsoft realease patches for windows. But i cannot find any information
about if Microsoft SQL 2000 & 2005 are affected by this change.
Thank you
SQL Server gets its date and time from the operating system. Effectively,
it doesn't need to know anything about daylight savings time.
"Destin" <Destin@.discussions.microsoft.com> wrote in message
news:3739B03C-E71F-4CA6-8DAF-5189A22A7162@.microsoft.com...
> As you know the daylight saving time will change in 2007
> http://www.microsoft.com/windows/timezone/dst2007.mspx
> Microsoft realease patches for windows. But i cannot find any information
> about if Microsoft SQL 2000 & 2005 are affected by this change.
> Thank you
|||Ok, but i just want to be sure, because SharePoint is using the time of the
OS but SharePoint will need a patch (so maybe is the same thing for
SQL)(http://www.microsoft.com/windows/timezone/wss.mspx)
Do you know where i can find the official information from Microsoft.
Regards,
"Aaron Bertrand [SQL Server MVP]" wrote:

> SQL Server gets its date and time from the operating system. Effectively,
> it doesn't need to know anything about daylight savings time.
>
>
> "Destin" <Destin@.discussions.microsoft.com> wrote in message
> news:3739B03C-E71F-4CA6-8DAF-5189A22A7162@.microsoft.com...
>
>
|||> Ok, but i just want to be sure, because SharePoint is using the time of
> the
> OS but SharePoint will need a patch (so maybe is the same thing for
> SQL)(http://www.microsoft.com/windows/timezone/wss.mspx)
I believe there must be some data somewhere in sharepoint that needs to be
changed.
Anyway, the update is not released yet.
If there IS a forthcoming update to SQL Server (which I can't imagine) I
believe it will be released in much the same way, and you will hear about
it.

> Do you know where i can find the official information from Microsoft.
I don't think there will be any official information. I drive a Touareg and
I don't get notified when there is a recall on a Jetta. :-)
sql

No comments:

Post a Comment