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
FROM Posts p1
JOIN Posts p2
  on p1.AcceptedAnswerId = p2.Id
WHERE Year(p1.CreationDate) = '2017' 
and p1.AcceptedAnswerId is not null
--and DAYDIFF > 1

Enter Parameters

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