title: How to query DATETIME field using only date in Microsoft SQL Server?
body: <p>I have a table TEST with a <code>DATETIME</code> field, like this:</p>
  <pre class="lang-none prettyprint-override"><code>ID NAME DATE
  1 TESTING 2014-03-19 20:05:20.000
  </code></pre>
  <p>What I need a query returning this row and every row with date 03/19/2014, no matter what the time is. I tried using</p>
  <pre class="lang-sql prettyprint-override"><code>select * from test where date = '03/19/2014';
  </code></pre>
  <p>But it returns no rows. The only way to make it work that I found is to also provide the time portion of the date:</p>
  <pre class="lang-sql prettyprint-override"><code>select * from test where date = '03/19/2014 20:03:02.000';
  </code></pre>