Posts closed since 01/2012 by month DDD

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

SELECT cast (year(p.CreationDate) as  varchar(10)) + '/' + cast(month(p.CreationDate) as varchar(19)) as dt
, count(p.Id) as pcount
from Posts AS p
Where p.CreationDate > '2012-01-01' 
group by year(p.CreationDate), month(p.CreationDate)

Enter Parameters

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