0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

SELECT top 100
    DATEADD(month, DATEDIFF(month, 0, CreationDate), 0) AS Month,
    CreationDate  
  FROM
    Posts 
  WHERE
    PostTypeId = 1 -- Question
  
SELECT
    DATEADD(month, DATEDIFF(month, 0, CreationDate), 0) AS Month,
    CreationDate
  FROM
    Posts
  WHERE
    PostTypeId = 2 -- Answer

view current version

edited apr 2

created apr 2 rene