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

select count(id) from Posts where convert(DATETIME, floor(convert(FLOAT, CreationDate))) = '2010-05-31 12:00:00'

fork query

created jun 21 10 anonymous