title: SQL DATETIME query
body: <p>Hi im trying to compare two dates in MySQL via a query, one is a date when an article was first posted and the second date is for when it should be removed by the query (after 365 days, ran by a cron task every 30 minutes.), below is my SQL query  </p>
  
  <pre><code>DELETE FROM $wpdb-&gt;posts WHERE post_type = 'business' AND DATEDIFF(NOW(), post_date_gmt) &gt; 2 
  </code></pre>
  
  <p>My date is held in the database in this format <code>2011-05-26 13:10:56</code> so my question is will the DATETIME query honour the exact date <strong>and time</strong> or when cron is ran at the 365th day delete the article even if there are still <code>13:10:56</code> left before it is actually 365 days old?</p>
  
  <p>Regards</p>