Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT COUNT(LEFT(CreationDate,11)) FROM Posts WHERE RIGHT(LEFT(CreationDate,11),4) = 2017 SELECT COUNT(CreationDate) FROM Posts WHERE DATEPART(YYYY, CreationDate) = 2017