title: Mysql how to get exact day and time between two dates
body: <p>I am passing date and time as input.</p>
  
  <p>'2015-01-12 10:30:00' and '2015-01-13 11:30:00' like this.
  we can find the days, hours, minuets, seconds etc between the timestamps. by using the FUNCTION called <strong>timestampdiff()</strong>.</p>
  
  <p>I tried this query.</p>
  
  <p><code>SELECT TIMESTAMPDIFF(HOUR,'2015-01-12 10:30:00','2015-01-13 11:30:00')/24 FROM DUAL</code></p>
  
  <p>but it gives me output like <strong>1.04</strong>.</p>
  
  <p>My requirement is exact day and hours between that two dates.</p>
  
  <p>Ex:
   '2015-01-12 10:30:00' and '2015-01-13 11:30:00' for this </p>
  
  <p><strong>OUTPUT :</strong> 
  1 day and 1 hrs.</p>
  
  <p>thank you.</p>