0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT 
    DATEADD(month, DATEDIFF(month, 0, CreationDate), 0) AS Month,
    eomonth(creationdate) [end of 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

fork query

edited apr 2

created apr 2 rene