title: SQL Server convert to optimal short date
body: <p>What is the most optimal short date to convert  to in SQL Sever to use in a predicate.</p>
  
  <p>I have a date <code>2013-06-11 15:06:27.000</code> and want to use the short date part <code>2013-06-11</code> in a predicate. </p>
  
  <p>What would be the best short date to convert to in SQL Server for this purpose? </p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="nofollow">MSDN - Date convert</a></p>