Longest gap from answering to accepting (markdown version)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT '| [' + q.Title + '](https://scifi.stackexchange.com/a/' + CAST(a.Id AS varchar) + ')',
       ' | ' + CONVERT(varchar, a.CreationDate, 120) AS [Answer Time],
       ' | ' + CONVERT(varchar, v.CreationDate, 120) AS [Accept Time],
       ' | [' + ua.DisplayName + '](https://scifi.stackexchange.com/users/' + CAST(a.OwnerUserId AS varchar) + ')' AS Answerer,
       ' | [' + uq.DisplayName + '](https://scifi.stackexchange.com/users/' + CAST(q.OwnerUserId AS varchar) + ')' AS Questioner,
       ' | ' + CONVERT(varchar, DATEDIFF(s, a.CreationDate, v.CreationDate) / 86400)
     + ':'
     + CONVERT(varchar, DATEADD(ms, (DATEDIFF(s, a.CreationDate, v.CreationDate) % 86400) * 1000, 0), 114) + ' |'
     AS [Difference]
FROM Posts a
JOIN Votes v ON a.Id = v.PostId
JOIN Posts q ON a.ParentId = q.Id
JOIN Users ua ON a.OwnerUserId = ua.Id
JOIN Users uq ON q.OwnerUserId = uq.Id
WHERE VoteTypeId = 1
AND DATEDIFF(s, a.CreationDate, v.CreationDate) > 31557600
ORDER BY DATEDIFF(s, a.CreationDate, v.CreationDate) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results