SELECT p1.Id, p1.CreationDate, p2.Id, p2.CreationDate, DA...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

SELECT p1.Id, p1.CreationDate, 
       p2.Id, p2.CreationDate, 
       DATEDIFF(year, p1.CreationDate, p2.CreationDate) as YEARDIFF,
       DATEDIFF(day, p1.CreationDate, p2.CreationDate) as DAYDIFF,
       DATEDIFF(dayofyear, p1.CreationDate, p2.CreationDate) as DAY2DIFF
FROM Posts p1
JOIN Posts p2
  on p1.AcceptedAnswerId = p2.Id
WHERE Year(p1.CreationDate) = '2017' 
and p1.AcceptedAnswerId is not null
order by DAYDIFF DESC

Enter Parameters

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