title: GETDATE() but without hours
body: <p>I need to call <code>getdate()</code> and I need a <code>datetime</code> returned, however without the current time, e.g. today it should return the following, no matter what time it is called:</p>
  
  <pre><code>2013-09-26 00:00:00.000
  </code></pre>