title: sql query for specific date interval
body: <pre><code>id   name         mydate                   
  1     co        2011-02-10 07:25:02  
  2     Carl      2011-02-10 07:26:02
  .
  .
  .
  10000   Caroline  2011-02-18 22:44:08
  </code></pre>
  
  <p>I have a database like that, I wanna search through for a specified interval such as (1 hour). For instance, I want to see the records between 07 AM and 08 AM among the all records for all days. And then, I will use each day's 7 AM and 8 AM for further process. How can I do that in C#?  </p>