<p>How can I select 12/20/2008 in <code>where</code> clause of sql?</p> <p>The server is SQL server 2005.</p> <pre class="prettyprint"><code>select * from tblErrorLog where errorDate = '12/20/2008' </code></pre>

<pre class="prettyprint"><code>WHERE datetime_column >= '20081220 00:00:00.000' AND datetime_column < '20081221 00:00:00.000' </code></pre>

Datetime in where clause

How can I select 12/20/2008 in where clause of sql?

The server is SQL server 2005.

select * from tblErrorLog where errorDate = '12/20/2008'

374

asked Dec 22 '09 16:12

WHERE datetime_column >= '20081220 00:00:00.000'   AND datetime_column < '20081221 00:00:00.000'

answered Oct 02 '22 03:10

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