title: Check if a time is between two times (time DataType)
body: <p>I have a table that has a column "Created" as a datetime.</p>
  
  <p>I'm trying to query to check if the time for the Created value is between two times.</p>
  
  <p>The Created datetime for the first row is '2013-07-01 00:00:00.000' (Midnight) and I'm trying to query for items with a time between 11PM and 7AM.</p>
  
  <pre><code>select *
  from MyTable
  where CAST(Created as time) between '23:00:00' and '06:59:59'
  </code></pre>
  
  <p>But no results are returned.</p>
  
  <p>Do I need to convert my times to datetimes?</p>