title: Select a date without time (SQL Server (+)
body: <p>I would like to retrieve a date minus 1 year, but without time notation. </p>
  
  <p>The following query</p>
  
  <pre><code>SELECT DATEADD(year, -1, GETDATE())
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>2015-03-30 10:48:04.220
  </code></pre>
  
  <p>What I want is <code>2015-03-30 00:00:00:000</code></p>
  
  <p>Similar to: </p>
  
  <pre><code>(DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0))
  </code></pre>
  
  <p>Which results in: <code>2016-03-30 00:00:00.000</code></p>
  
  <p>What is the correct or easiest way to do this? </p>