0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

-- Enter Query Title
-- Enter Query Description

SELECT count(convert(DATETIME, convert(VARCHAR, CreationDate, 111))), convert(DATETIME, convert(VARCHAR, CreationDate, 111)) from posts group by convert(DATETIME, convert(VARCHAR, CreationDate, 111)) order by convert(DATETIME, convert(VARCHAR, CreationDate, 111)) desc

fork query

created jun 21 10 anonymous