MySQL dateformat %c does not return results?
<p>Why MySQL <code>dateformat</code> function does not fetch rows with a month in the query?</p>

<pre><code>SELECT p.*  
FROM article AS p
WHERE p.parent_id = '6' 
AND DATE_FORMAT(p.backdated_on, '%Y %c') = '2015 8'  
GROUP BY p.article_id  
ORDER BY p.backdated_on DESC  
LIMIT 0, 6 
</code></pre>

<p>I have one row with the <code>backdated_on</code> of <code>2015-11-08 19:10:04</code></p>

<p>Any ideas why and how I can fix this?</p>