title: Datetime and SELECT * FROM table WHERE date = TODAY
body: <p>The column (date) in the database says "2013-10-14 14:37:38" for example.</p>
  
  <p>How can I edit <code>$todaysDate</code> to display ALL dates today? I know that I have to use % somewhere but I have tried a lot of ways without success. :/</p>
  
  <p>My code is below:</p>
  
  <pre><code>$todaysDate = date("Y-m-d");
  
  $query_today = $db-&gt;prepare("SELECT * FROM table WHERE date=:date");
  $query_today-&gt;bindParam(":date", $todaysDate);
  $query_today-&gt;execute();
  </code></pre>
  
  <p><strong>UPDATE</strong>
  Nothing below is working. I just want to select all dates in the database from a simple <code>date("Y-m-d")</code>. If the date is "2013-10-14 14:37:38" in the database I want to select it with just 2013-10-14. Something like <code>date("Y-m-d%")</code>.</p>