Longest time (in days) to accept answer, global

1

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

select top 100 p.id as [Post Link], datediff(day,  a.creationdate, v.creationdate ) as elapsed_time,
a.creationdate as answered,
v.creationdate as accepted
from posts p, posts a, votes v
where a.parentid = p.id
and p.acceptedanswerid = v.postid
and v.postid = a.id
and v.votetypeid = 1
     order  by v.creationdate - a.creationdate desc

Enter Parameters

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