Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

Is there any chance of including the "answer accepted date" in the Data Dump? Specifically I mean when you hover over the accepted answer checkmark you get a tooltip:

The question owner accepted this as the best answer xx units ago

Can we include that time property in the dump....or is it already there and I'm just missing it?

share|improve this question
up vote 2 down vote accepted

The date is already in there, but the time is not. (Not in Data Explorer anyways... it may be in the data dump itself, but I just deleted the last one and haven't downloaded the new one.)

Anyway, run this:

SELECT TOP 100 * FROM Votes WHERE VoteTypeId = 1

You can see the dates show up in the CreationDate column, but the times are all 12:00.

Upvotes and downvotes are anonymized by both stripping the source user id and the time, and I assume this was carried through to the accepted date. However, I don't think this makes sense, since the accepted times are publicly visible in the system.

I think I'd call this a bug, actually.

share|improve this answer
There goes my "Tuesday has the most accepted answers" theory: Thanks Jon, that's exactly what I needed! – Nick Craver Aug 3 '10 at 22:25
@NickCraver Did you see my queries here? – Mark Hurd Aug 4 '10 at 2:54
@Mark - Yup, I found those results interesting as this case I was specifically after accepted answers, maybe you could add that column to your results to make those queries even more useful? – Nick Craver Aug 4 '10 at 3:23
@NickCraver Done. – Mark Hurd Aug 4 '10 at 12:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .