title: How can I find all results on a date between two dates?
body: <p>In a SQL Server table there are two dates: a start datetime and an end datetime. Now I want to search for all results on a date time. For example this table:</p>
  
  <pre><code>id|name|starttime|endtime
  1|Peter|2014-07-22 07:00|2014-07-22 15:00
  2|John|2014-07-22 08:00|2014-07-22 17:00
  3|Martin|2014-07-22 07:30|2014-07-22 12:00
  </code></pre>
  
  <p>Now I want to now all results who match on 2014-07-22 07:50</p>
  
  <p>I take a look to <code>BETWEEN</code> and <code>DATEDIFF</code> but think that doesn't work for it.</p>