When were this question's answers upvoted?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

SELECT 
v.CreationDate AS "Vote Date",
a.Id AS "Answer ID", 
DATEDIFF(day, a.CreationDate, v.CreationDate) AS Delay, 
a.CreationDate AS "Answer Date", 
a.Score AS "Answer Score", 
u.DisplayName AS "Answerer", 
a.ParentId AS "Question ID", 
q.CreationDate AS "Question Date",
q.Title AS "Question Title"
FROM Posts a
JOIN Posts q ON a.ParentId = q.Id
JOIN Votes v ON v.PostId = a.Id
JOIN Users u ON u.Id = a.OwnerUserId
WHERE q.Id = ##QuestionId:int## -- Example: 90646
ORDER BY Delay ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results