title: How can I use the WHERE clause to filter a date and range of time?
body: <p>I'm trying to find customer engagements that occurred at specific date and times, </p>
  
  <p>I think I have the date part correct however I can't seem to set the time right.</p>
  
  <pre><code>SELECT EngagementNumber,
         StartDate,
         StartTime
  FROM Engagements
  WHERE StartDate LIKE '2012-10-%%'
        AND StartTime BETWEEN '12:00:00.0000000' AND '17:00:00.0000000';
  </code></pre>