title: Recordset for todays date using CURRENT_TIMESTAMP
body: <p>hopefully this is an easy one.</p>
  
  <p>I have a query that I want to produce results for todays date only based on a column (record_date)  that uses CURRENT_TIMESTAMP.</p>
  
  <p>so my query goes...</p>
  
  <pre><code>Select columns FROM fields WHERE table.record_date = DATE_SUB(NOW());
  </code></pre>
  
  <p>This is throwing up an error... :(</p>
  
  <hr>
  
  <p>Thanks for you help....So i tried....</p>
  
  <p>SELECT * FROM <code>daily_record</code> WHERE <code>record_date</code> = CURDATE()</p>
  
  <p>but it yielded no result.</p>
  
  <p>Here is a sample of the data in the column i am searching...</p>
  
  <p>2011-03-31 11:28:37,
  2011-03-31 11:28:37,
  2011-03-31 11:28:37,
  .....</p>
  
  <p>Does it matter that the time is also saved?</p>