title: mysql start date and end date
body: <p>I have been trying to get particular dates from date and end date<br>
  eg 01-01-2016 to 12-31-2016 dates only. But iam getting 2015 date only<br>
  this is my query <br></p>
  
  <pre><code>$query = $this-&gt;db-&gt;query("SELECT date FROM `table` WHERE date between '1/1/2016' and '12/29/2016'");
         echo $this-&gt;db-&gt;last_query(); exit;
      if ($query == true) {
          foreach ($query-&gt;result() as $t) {
              echo $t-&gt;date . '&lt;br&gt;';
          }
      } else { return false; }
  </code></pre>
  
  <p>but im getting 2015 records </p>