title: TSQL strip date from datetime
body: <p>What is the best way to strip the <em>date</em> from a DATETIME so only <em>time</em> is left to do a comparison? </p>
  
  <p>I know I can do the following: </p>
  
  <pre><code>CONVERT(DATETIME, CONVERT(VARCHAR(8), GETDATE(),8))
  </code></pre>
  
  <p>But this involves convert and characters. If I wanted to check whether a time (including minutes) was between two other times stored in DATETIME columns, is there an elegant way to do this without having to rely on converting to character strings?</p>