title: SQL Statement to Select Day Interval
body: <p>How can I get the range between a day dynamically for e.g. BETWEEN 23.05.2012 00:00  AND 23.05.2012 23:59 using MSSQL ? <br>I got the first part;</p>
  
  <pre><code>WHERE
  AND s.SCHEDULE_START_DATE BETWEEN dateadd(DAY, datediff(DAY, 0, getdate()), 0) AND FILL HERE
  </code></pre>