title: SQL Server see which time is greater
body: <p>I need to pull the time from a field in an existing table which is stored as SMALLDATETIME.</p>
  
  <p>An example of the value stored is as follows:</p>
  
  <pre><code>Jun  4 1900 11:30AM
  </code></pre>
  
  <p>I need to grab the time part (hours and minutes) and see if it is less than whatever the current time is now.</p>
  
  <pre><code>EG IF @CutoffTime &lt; @CurrentTime THEN
  BEGIN
  ....
  END
  </code></pre>
  
  <p>Is there an easy way to do this in SQL Server?
  Thanks!</p>