select count(id) from Posts where convert(DATETIME, con...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

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, convert(VARCHAR, CreationDate, 111)) like '2010-05-31 12:00:00'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results