title: Efficient way to convert second to minute and seconds in sql server 2005
body: <p>Suppose I have 90 seconds. If I want to display the result in terms of minutes and second, I do it by using</p>
  
  <pre><code>select Time= '0' + CAST( 90/60 as varchar(2)) + ':' +  CAST( 90%60 as varchar(2)) 
  </code></pre>
  
  <p>The output is</p>
  
  <blockquote>
    <p>Time<br>
     01:30</p>
  </blockquote>
  
  <p>I have appended 0(zero) because if you do a <code>select getdate()</code> the output will be </p>
  
  <blockquote>
    <p>yyyy-mm-dd hh:mm:ss:ms</p>
  </blockquote>
  
  <p>What is the standard way and recommended practice to do such a conversion?</p>
  
  <p>Thanks</p>