title: Selecting all rows that fall between midnight and a given date
body: <p>In SQL Server 2008, I have a stored procedure that takes an input date. I'd like to select all rows that start at midnight on that date to 11:59pm.</p>
  
  <pre><code>CREATE PROCEDURE MyProc
  @InputDate DATETIME
  AS
  SELECT * FROM MyTable WHERE DateField &gt;= @InputDate
  </code></pre>
  
  <p>So I want to be able to call this proc similar to like so:</p>
  
  <pre><code>EXEC MyProc @InputDate=CONVERT(DATETIME, '3/5/2013')
  </code></pre>
  
  <p>And it should return all rows with a date between <strong>'3/5/2013 0:0:0'</strong> AND <strong>'3/5/2013 11:59:59'</strong>. The input date should ignore the time component and just look at the date and append its own time component (at least I'm thinking it should)</p>
  
  <p>Can someone point me in the right direction?</p>