title: how to get 2 digits after decimal point in tsql?
body: <p>I am having problem to format digits in my select column.I used FORMAT but it doesn't work.
  Here is my column:</p>
  
  <pre><code>sum(cast(datediff(second, IEC.CREATE_DATE, IEC.STATUS_DATE) as float) / 60) TotalSentMinutes    
  </code></pre>
  
  <p>I used this:</p>
  
  <pre><code>FORMAT(sum(cast(datediff(second, IEC.CREATE_DATE, IEC.STATUS_DATE) as float) / 60),2) TotalSentMinutes  
  </code></pre>
  
  <p>ERROR: </p>
  
  <blockquote>
    <p>'format' is not a recognized built-in function name.</p>
  </blockquote>
  
  <p>How can I format this calculation?</p>