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 select count(id) from Posts where convert(DATETIME, floor(convert(FLOAT, getdate()))) = '2010-05-31 12:00:00'