2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of Ethereum, the decentralized application platform and smart contract enabled blockchain

SELECT CONVERT(DATE, CreationDate, 101) AS [day], COUNT(*) as [count]
FROM Posts

 -- query questions only --
WHERE PostTypeId = 1

 -- cut off private beta --
AND CONVERT(DATE, CreationDate, 101) > '2016-02-01 00:00:00'

GROUP BY CONVERT(DATE, CreationDate, 101)
ORDER BY CONVERT(DATE, CreationDate, 101)

fork query

edited apr 27 16 5chdn

created may 23 14 anonymous