title: Timestamp Difference and get hours, minutes, and seconds alone
body: <p>So i have 2 tables in each row, i used this to get the avg time in minutes.</p>
  
  <pre><code>SELECT Sec_to_time (Avg (Timestampdiff (second, `survival`, `lastupdate`)))
  FROM   main
  </code></pre>
  
  <p>But i want to get the hours, minutes, and seconds alone so i can echo them in php.</p>