1

Please login or register to vote for this query.

(click on this box to dismiss)

Number of days between the question is asked and the accepted answer is posted.

Q&A for professional and enthusiast programmers

-- Longest time when an accepted answer is posted
-- Number of days between the question is asked and the accepted answer is posted.


select top 100 cast(a.creationdate - q.creationdate as float) as Days, q.id as [Post Link] from posts q
join posts a on a.id = q.acceptedanswerid
order by Days desc

fork query

created aug 17 10 anonymous