SELECT a.CreationDate as 'answer_date', a.Id as 'answer_i...

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT 
a.CreationDate as 'answer_date', a.Id as 'answer_id', o.CreationDate as 'post_date', o.Id as 'post_id'
FROM 
  Posts o
    INNER JOIN
  Posts a ON a.Id = o.AcceptedAnswerId
WHERE year(a.CreationDate) = '2017' AND year(o.CreationDate) = '2017'
ORDER BY o.CreationDate

Enter Parameters

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