title: What is the best way to truncate a date in SQL Server?
body: <p>If I have a date value like <code>2010-03-01 17:34:12.018</code></p>
  
  <p>What is the most efficient way to turn this into <code>2010-03-01 00:00:00.000</code>?</p>
  
  <p>As a secondary question, what is the best way to emulate Oracle's <code>TRUNC</code> function, which will allow you to truncate at Year, Quarter, Month, Week, Day, Hour, Minute, and Second boundaries?</p>