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