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)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

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