title: convert yyyy-mm-dd hh:mm:ss to yyyy-mm-dd in sql
body: <p>I need to convert yyyy-mm-dd hh:mm:ss.msec to yyyy-mm-dd in sql.</p>
  
  <p>I tried </p>
  
  <pre><code>CONVERT(DATETIME,MIN(Vdaily_calender.VDC_day_date),120)
  </code></pre>
  
  <p>but getting same result.</p>
  
  <p>Please advise</p>
  
  <p>Thanks
      Ar</p>