title: MySQL Return Today's Records Using DATE from DATETIME Field
body: <p>I have a table called "actions" with a <code>DATETIME</code> column called "occurred". I'm trying to return the records for today by doing the following</p>
  
  <pre><code>SELECT * FROM `actions` WHERE `occurred` = DATE(NOW());
  </code></pre>
  
  <p>But I get an empty result set. If I take the <code>WHERE</code> clause out, I can see all 295 rows in the table and there's at least 30 rows from today. Later I will be writing another query to return all records between today's date and X amount of days in the past but before I can get there I need to know why this query is returning an empty result set.</p>
  
  <p>Thanks in advance.</p>