title: Find difference between two dates in PHP or MySQL
body: <p>This query does not return the records for january, but it returns records for february.</p>
  
  <pre><code>SELECT EventAsstCharged,CustomerName,EventID ,EventName,EventExpectedCharges,EventActuallyCharged,EventUserCharged,date_format(EventDate,'%d-%m-%Y') as EventDate ,EventTime FROM tblevent WHERE Status=1 AND date_format(EventDate,'%d-%m-%Y') between '01-01-2011' AND '20-02-2011' AND EntryUser=2 AND Status=1 ORDER BY EventID DESC
  </code></pre>
  
  <p>How to find the age between two dates using PHP or MySQL?</p>
  
  <pre>
  2009-09-24 21:09:36     2010-03-04 13:24:58
  </pre>