temp

0

Please login or register to vote for this query.

(click on this box to dismiss)

Travel Answers

Q&A for road warriors and seasoned travelers

select top 100 Id as [Post Link]
     , datediff(ms, creationdate, closeddate) [milli seconds]
     , creationdate
     , closeddate
     , deletiondate
from postswithdeleted
where closeddate is not null
and posttypeid = 1
and datediff(s, creationdate, closeddate) < 120
order by 1

Enter Parameters

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