title: sql query where date between two times
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/885188/specific-time-range-query-in-sql-server">Specific Time Range Query in SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>For example I have 3 rows:</p>
  
  <pre><code>Id      Date
  1       '2011-01-02 09:14:23.0000000' 
  2       '2011-02-15 10:15:47.0000000' 
  3       '2011-03-18 21:12:33.0000000' 
  </code></pre>
  
  <p>And I whant to take only rows, where TIME between 09:00 and 11:00 and any date.</p>
  
  <p>I need this in result set:  </p>
  
  <pre><code> Id      Date
      1       '2011-01-02 09:14:23.0000000' 
      2       '2011-02-15 10:15:47.0000000' 
  </code></pre>
  
  <p>Thanks</p>