title: Datetime DATE DIFF not working as expected
body: <p>I have a field <code>date_confirmed</code> which is a <code>datetime</code>.</p>
  
  <p>So an example of the contents would be </p>
  
  <blockquote>
    <p>2011-01-03 20:54:41</p>
  </blockquote>
  
  <p>The where clause I built to extract recent rows from this table based on the <code>date_confirmed</code> is as follows...</p>
  
  <pre><code>WHERE DATEDIFF(g.date_confirmed, CURDATE()) &lt;= 28
  </code></pre>
  
  <p>I am using PHP with MySQL and I want to only extract rows where the date in <code>date_confirmed</code> is less than 28 days.</p>
  
  <p>Can someone help me / points me in a better direction?</p>
  
  <p>Thanks.</p>