StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
9341282
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-02-18T12:48:43.527
FavoriteCount
0
LastActivityDate
2014-11-15T06:04:02.307
LastEditDate
2014-11-15T06:04:02.307
LastEditorUserId
256431
OwnerUserId
256431
ParentId
4605983
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
I can reproduce this using .NET 4.0 and 2.0/3.5 on XP/Win2k3/Vista. The issue is DST was in a different state to now, and .NET is processing this difference differently to Explorer and <code>Scripting.FileSystemObject</code>. (You can see a similar issue when extracting files from a zip file when DST is different to when the files were zipped.) Via Reflector, the reason .NET differs from the non .NET code paths is that all three local datestamps in <code>IO.File</code> (and <code>IO.FileInfo</code>) are implemented as getting the Utc datestamp and applying <code>.ToLocalTime</code>, which determines the offset to add based upon whether DST was happening in the local timezone for the Utc time. I also checked, by changing the date to July 1 last year, creating a file and watching the timestamp when I return to the current date (March 16) (I'm in South Australia, so we're in DST now and were not on July 1), and Windows (and presumably <code>FileSystemObject</code>) adds the DST in place NOW so the time displayed actually changes. So, in summary, .NET is more correct. But if you want the incorrect, but same as Explorer, date use: <pre><code>Public Function GetLastAccessTime(ByVal FilePath As String) As Date Return IO.File.GetLastAccessTimeUtc(FilePath) _ .Add(TimeZone.CurrentTimeZone.GetUtcOffset(Now)) End Function </code></pre> This has been discussed on <a href="http://blogs.msdn.com/b/oldnewthing/archive/2003/10/24/55413.aspx" rel="nofollow">Raymond Chen's blog</a> (where the summary is: .NET is intuitively correct but not always invertible, and Win32 is strictly correct and invertible).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIO.File.GetLastAccessTime is off by one hour
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USMark Hurd
UserOwnerUserId
1. USMark Hurd
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POIO.File.GetLastAccessTime is off by one hour
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.