title: Select month from datetime column
body: <p>I have a table that has a datetime column  named :<strong>completed_date</strong> (2016-05-27 04:08:53). I would like to select all data for this <strong>current month</strong> while ignoring the time. Something like this: </p>
  
  <pre><code>  $query = mysqli_query($dbc, " select  * from eob_posting where
    completed_date=DATE(NOW())");
  </code></pre>
  
  <p>How can i remove the time so that the clause <strong>where</strong> considere only the date ?</p>