title: Float to time conversion in my sql
body: <p>I have one <strong>float</strong> field hours in table for inserting time as following :</p>
  
  <pre><code>If 6.3 means 6 hours and 30 minutes
  If 8.04 means 8 hours and 4 minutes
  </code></pre>
  
  <p>Now I want to add these all float values to another column new_hours with time format</p>
  
  <p>I need to add entries like following :</p>
  
  <pre><code>If 6.3 in hours column then 06:30:00 in new_hours column
  
  If 8.04 in hours column then 08:04:00 in new_hours column
  </code></pre>
  
  <p>I have lot of entries in hours column and i want to add new_hours from hours by one single my sql query.</p>
  
  <p>Any help will be appriciated.Thanks.</p>