title: Select length as minute:seconds format
body: <p>Trying to convert seconds to a minute:seconds format.
  e.g. 207 seconds would be 3:27
  I have a table with column length that has the length of songs stored in seconds.</p>
  
  <p>Using this query almost works, however, when a song should be 3:03 it will instead show 3:3</p>
  
  <pre><code>select concat(Length/60, ':', Length%60) as Length from songs
  </code></pre>