title: Query to Select Between Two Times of Day
body: <p>I am trying to build a query that will select based on a <code>DateTime</code> column <code>SyncDate</code>.  </p>
  
  <p>As some background, the table I query from gets imports daily in the thousands at the exact same time everyday. I want to find the entries that did not import at the "regular" time of day.  </p>
  
  <p>Therefore, I want to query where the time in the <code>DateTime</code> column is between two times: lets say 14:00-14:30 (2-230) on ANY day/month/year period.  </p>
  
  <pre><code>SELECT * FROM MyTable
  WHERE DatePart(SyncDate, ..?) BETWEEN (14:00..?) and (14:30..?)
  </code></pre>
  
  <p>The <code>DatePart</code> function seems to be what I need, but I don't understand how to apply it to this situation. Your help is much appreciated oh great queriers.</p>
  
  <p>EDIT: I was mistaken, I am running SQL-Server-2005 as my backend.  Sorry!</p>