title: Check date between two dates in T-SQL
body: <p>I have a stored procedure where want check that a date is between a fixed date and the current date/time (with <code>GETDATE()</code>):</p>
  
  <pre><code>SELECT
      a, b
  FROM myTbl
  WHERE
      DATE BETWEEN 'Day start datetime' AND GETDATE()
  </code></pre>
  
  <p>...for example :</p>
  
  <pre><code>WHERE
      DATE BETWEEN '2013-09-10 00:00:00.00' AND 'GETDATE()'
  </code></pre>
  
  <p>How to do it?</p>