title: Rounding SQL DateTime to midnight
body: <p>I am having a small problem with my SQL query. I'm using the GETDATE function, however, let's say I execute the script at 5PM, it will pull up records between 12/12/2011 5PM to 12/18/2011 5PM. How can I make it pull up records for the whole entire 12/12/2011 - 12/18/2011 basically ignore time.</p>
  
  <p>My script:</p>
  
  <pre><code>WHERE Orders.OrderStatus = 'Shipped'  
  AND Orders.ShipDate &gt; (GETDATE()-6)  
  </code></pre>