title: MySQL - DATE_ADD month interval
body: <p>I face a problem with the function <code>DATE_ADD</code> in MySQL.</p>
  
  <p>My request looks like this :</p>
  
  <pre><code>SELECT * 
  FROM mydb 
  WHERE creationdate BETWEEN "2011-01-01" AND DATE_ADD("2011-01-01", INTERVAL 6 MONTH) 
  GROUP BY MONTH(creationdate)
  </code></pre>
  
  <p>The problem is that, in the results, -I think- because <em>June</em> has only 30 days, the function doesn't work properly as I have the results of the first of <em>July</em>.</p>
  
  <p>Is there a way to tell <code>DATE_ADD</code> to work well and take the right number of days within a month?</p>