0

Please login or register to vote for this query.

(click on this box to dismiss)

Best time when you can get the most valuable answer

Q&A about the site for people interested in improving and participating in the patent system

-- SELECT post time of accepted answers, 
-- SELECT CreationDate FROM Posts WHERE PostTypeId = 2 AND AcceptedAnswerId = ''
SELECT 
  Posts.CreationDate 
FROM 
  Posts, 
  (SELECT TOP 100 AcceptedAnswerId FROM Posts WHERE  AcceptedAnswerId >= 1) 
  AS 
    AcceptedAnswers
WHERE
  Posts.Id = AcceptedAnswers.AcceptedAnswerId
  AND
  Posts.PostTypeId = 2

view current version

edited apr 30 13

created apr 30 13 LifeH2O