title: Minus one date from another in MySQL request?
body: <p>I have table with <code>start_date</code> and <code>end_date</code>. I need to find the duration (<code>end_date-start_date</code>). Can someone suggest how I can do so in the query? Will I get a new variable with this somehow like <code>duration=end_date-start_date</code> in the query?</p>
  
  <p>EDIT 
  If I use mminus it gives me:</p>
  
  <blockquote>
    <p>2012-07-01 minus 2012-01-01 = 600</p>
  </blockquote>
  
  <p>How can it be 600 days in 6 months as 2011-07-27 - 2011-07-06 = 21? So i assume it's days?<br>
  Is there function to get actually how many months it even if date is in middle of month. 
  e.g. like "3rd june" and "27 july" is 2 month </p>