Close votes cast per day

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select DATEADD(D, 0, DATEDIFF(D, 0, creationdate)) as 'Date', count(id) as 'Close votes cast'
from votes where VoteTypeId = 6
group by DATEADD(D, 0, DATEDIFF(D, 0, creationdate))
order by 'Date' desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results