|
Home > Archive > MS SQL Server > October 2006 > Windows timestamp vs. SQL Server time
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Windows timestamp vs. SQL Server time
|
|
| Kevin3NF 2006-10-31, 12:15 am |
| 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
| |
| Dave Patrick 2006-10-31, 12:15 am |
| 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
|
|
|
| |
| Kevin3NF 2006-10-31, 12:15 am |
| 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
> |
> |
> |
>
>
| |
|
|
|
|
|