title: CONVERT decimal DAYS to TIME format
body: <p>Hello iam a newbie in sql and i need your help. </p>
  
  <p>I have the following table:</p>
  
  <pre><code>    start_date      |     end_date          
  02.08.2012 09:27:19 |  06.08.2012 07:53:00  
  06.08.2012 06:58:58 |  06.08.2012 13:42:33
  05.06.2012 14:35:58 |  05.06.2012 14:42:31
  </code></pre>
  
  <p>I need to display the duration between start_date and end_date.</p>
  
  <p>I did it like this: <strong>end_date - start_date = duration</strong><br>
  but it displays a decimal value (see below table - field duration).</p>
  
  <p><strong>I need field duration to display like this: HH:MM:SS</strong>  -  not decimal.</p>
  
  <pre><code>    start_date      |     end_date         |         duration        | I need it like this
  02.08.2012 09:27:19 |  06.08.2012 07:53:00 | --&gt; 3.93450231481481    |    94:25:41
  06.08.2012 06:58:58 |  06.08.2012 13:42:33 | --&gt; 0.280266203703704   |    06:43:35
  05.06.2012 14:35:58 |  05.06.2012 14:42:31 | --&gt; 0.0045486111111...  |    00:06:33
  </code></pre>
  
  <p>If something is uncertain i will try to explain.
  I hope you can help me. Have a nice day.</p>