title: how to subtract two time in sql server?
body: <p>So I don't know how to subtract two <code>time(hh:mm:ss)</code> in sql server.</p>
  
  <p>This is my statement:</p>
  
  <pre><code>where   
   ( CONVERT(TIME(7), [EndWork], 102)) - ( CONVERT(TIME(7), [StartWork], 102)) &lt;
   CONVERT(TIME(7), ' 8:30:00', 102)
  </code></pre>