3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

SELECT TOP(100) Id AS [Post Link],
                datepart(hh, ClosedDate - CreationDate) * 3600
                + datepart(mi, ClosedDate - CreationDate) * 60
                + datepart(ss, ClosedDate - CreationDate)
                as [Closed in X seconds]
FROM Posts
WHERE ClosedDate IS NOT NULL
ORDER BY ClosedDate - CreationDate

fork query

edited nov 3 12

created nov 3 12 anonymous