convert yyyy-mm-dd hh:mm:ss to yyyy-mm-dd in sql
<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>