How Quickly are Questions Closed Today?

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/153469/how-quickly-are-questions-closed-today

Spanish Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Spanish language

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


select floor(log10(datediff(s, creationdate, closeddate))) [sec.]
, count(*) [# of log(sec)]
from postswithdeleted
where closeddate is not null
and posttypeid = 1
group by floor(log10(datediff(s, creationdate, closeddate)))
order by floor(log10(datediff(s, creationdate, closeddate)))

Enter Parameters

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