title: Sql Server where clause between two dates not gives expected output
body: <p>This is my simple query to fetch dates using 'between' operator.</p>
  
  <pre><code>create table dummy (mydate datetime);
   insert into dummy values('2013-03-20 10:30:00.000');
   insert into dummy values('2013-03-21 10:30:00.000');
   insert into dummy values('2013-03-22 10:30:00.000');
   insert into dummy values('2013-03-23 10:30:00.000');
   insert into dummy values('2013-03-24 10:30:00.000');
   insert into dummy values('2013-03-25 10:30:00.000');
   insert into dummy values('2013-03-26 10:30:00.000');
   insert into dummy values('2013-03-27 10:30:00.000');
   insert into dummy values('2013-03-28 10:30:00.000');
   insert into dummy values('2013-03-29 10:30:00.000');
   insert into dummy values('2013-03-30 10:30:00.000');
  </code></pre>
  
  <p>The qiuery I m using is: 
  <code>select * from dummy where mydate between ('3/01/2013 12:00:00 AM') and ('3/30/2013 12:00:00 AM')</code></p>
  
  <p>Here  <code>2013-03-30 10:30:00.000</code> , should also be returned.</p>
  
  <p><a href="http://sqlfiddle.com/#!3/f7026/1" rel="nofollow">SQL FIDDLE</a></p>