What is the most optimal short date to convert to in SQL Sever to use in a predicate. 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. What would be the best short date to convert to in SQL Server for this purpose? MSDN - Date convert

<pre class="prettyprint"><code>Select Convert(DateTime, Convert(VarChar, GetDate(), 12)) </code></pre>

SQL Server convert to optimal short date

Select Convert(DateTime, Convert(VarChar, GetDate(), 12))

120

answered Jan 11 '23 07:01

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!