SELECT a.CreationDate as 'answer_date', o.CreationDate as...

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', o.CreationDate as 'post_date'
FROM 
  Posts o
    INNER JOIN
  Posts a ON a.Id = o.AcceptedAnswerId
WHERE year(a.CreationDate) = '2018' AND day(a.CreationDate) = '01'
AND year(o.CreationDate) = '2018' AND day(o.CreationDate) = '01'

Enter Parameters

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