Windows timestamp vs. SQL Server time

Odd issue with times that may or may not be related to Daylight savings

I have a SQL Server that has been merrily backing up files via a custom
script and inserting the current date/time as part of the file name.

The full backup happens at 12:15am ever Sunday and spits out a file similar
to:

MyDB_200610290015.bak

When I look at this file in Windows Explorer, I see a Date Modified of
10/28, 11:45 PM

Windows Application event log is also behind by an hour (11:45 event shows
the above file being created with the 12:15AM timestamp).  This has been
going on at least as far back as 10/15/06.  The Daylight Savings Time change
at 2:00AM 10/29 has everything matching again.  The system clock is set to
auto change DST.

SQL 2005/Windows 2003, but I see similar behavior on a Win2K/SQL2K box.

Seems like a Windows presentation issue, since all the file names and system
tables have the info recorded correctly.

All thoughts are appreciated.

Thanks,
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com

These may be of interest.

http://support.microsoft.com/kb/158588
http://www.codeproject.com/datetime/dstbugs.asp

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Kevin3NF" wrote:
| Odd issue with times that may or may not be related to Daylight savings
|
| I have a SQL Server that has been merrily backing up files via a custom
| script and inserting the current date/time as part of the file name.
|
| The full backup happens at 12:15am ever Sunday and spits out a file
similar
| to:
|
| MyDB_200610290015.bak
|
| When I look at this file in Windows Explorer, I see a Date Modified of
| 10/28, 11:45 PM
|
| Windows Application event log is also behind by an hour (11:45 event shows
| the above file being created with the 12:15AM timestamp).  This has been
| going on at least as far back as 10/15/06.  The Daylight Savings Time
change
| at 2:00AM 10/29 has everything matching again.  The system clock is set to
| auto change DST.
|
| SQL 2005/Windows 2003, but I see similar behavior on a Win2K/SQL2K box.
|
| Seems like a Windows presentation issue, since all the file names and
system
| tables have the info recorded correctly.
|
| All thoughts are appreciated.
|
| Thanks,
| --
| Kevin Hill
| 3NF Consulting
| http://www.3nf-inc.com/NewsGroups.htm
| http://kevin3nf.blogspot.com
|
|
|

Good stuff Dave, thanks :)

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"Dave Patrick" <DSPatrick@nospam.gmail.com> wrote in message
news:%23GCIEKE$GHA.4320@TK2MSFTNGP02.phx.gbl...
> These may be of interest.
>
> http://support.microsoft.com/kb/158588
> http://www.codeproject.com/datetime/dstbugs.asp
>
> --
>
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
>
> "Kevin3NF" wrote:
> | Odd issue with times that may or may not be related to Daylight savings
> |
> | I have a SQL Server that has been merrily backing up files via a custom
> | script and inserting the current date/time as part of the file name.
> |
> | The full backup happens at 12:15am ever Sunday and spits out a file
> similar
> | to:
> |
> | MyDB_200610290015.bak
> |
> | When I look at this file in Windows Explorer, I see a Date Modified of
> | 10/28, 11:45 PM
> |
> | Windows Application event log is also behind by an hour (11:45 event
> shows
> | the above file being created with the 12:15AM timestamp).  This has been
> | going on at least as far back as 10/15/06.  The Daylight Savings Time
> change
> | at 2:00AM 10/29 has everything matching again.  The system clock is set
> to
> | auto change DST.
> |
> | SQL 2005/Windows 2003, but I see similar behavior on a Win2K/SQL2K box.
> |
> | Seems like a Windows presentation issue, since all the file names and
> system
> | tables have the info recorded correctly.
> |
> | All thoughts are appreciated.
> |
> | Thanks,
> | --
> | Kevin Hill
> | 3NF Consulting
> | http://www.3nf-inc.com/NewsGroups.htm
> | http://kevin3nf.blogspot.com
> |
> |
> |
>
>

You're welcome.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Kevin3NF" wrote:
| Good stuff Dave, thanks :)
|
| --
| Kevin Hill
| 3NF Consulting
| http://www.3nf-inc.com/NewsGroups.htm
| http://kevin3nf.blogspot.com