title: Format result from TIMEDIFF in days:hours:min:sec
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5279079/mysql-convert-timediff-output-to-day-hour-minute-second-format">MySQL convert timediff output to day, hour, minute, second format</a>  </p>
  </blockquote>
  
  
  
  <p>I have a simple query which calculates time difference between two datetime as below:</p>
  
  <pre><code> SELECT TIMEDIFF( '2012-08-19 08:25:13', '2012-07-19 18:05:52' );
  </code></pre>
  
  <blockquote>
    <p>Output: 734:19:21</p>
  </blockquote>
  
  <p>The output is in hours:min:sec. However I want the output to be formatted as:  </p>
  
  <blockquote>
    <p>days:hours:min:sec</p>
  </blockquote>
  
  <p>How can I format the output?  </p>