1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scientists using computers to solve scientific problems

SELECT TOP(##num##)
s.Id AS [Suggested Edit Link],
s.PostId AS [Post Link],
s.OwnerUserId AS [User Link],
s.CreationDate, s.ApprovalDate,
DATEDIFF(month, s.CreationDate, s.ApprovalDate) AS Months,
DATEDIFF(day, s.CreationDate, s.ApprovalDate) AS Days,
DATEDIFF(hour, s.CreationDate, s.ApprovalDate) AS Hours,
DATEDIFF(minute, s.CreationDate, s.ApprovalDate) AS Minutes
FROM SuggestedEdits s JOIN posts p ON s.PostId=p.Id
WHERE (s.ApprovalDate IS NOT NULL) AND (p.PostTypeId IN (1,2))
ORDER BY DATEDIFF(minute, s.CreationDate, s.ApprovalDate) DESC

fork query

created dec 8 18 Martin20528