title: Filter by Dates in SQL
body: <p>I have a column in my table for dates (DateTime) and I am trying to create a WHERE clause that says, <code>WHERE dates BETWEEN 12-11-2012 and 12-13-2012</code></p>
  
  <p>A sample value of dates column = 2012-05-24 00:38:40.260</p>
  
  <p>I want to say WHERE dates BETWEEN MM-DD-YYYY and MM-DD-YYYY.</p>
  
  <p>I tried doing</p>
  
  <pre><code>WHERE dates BETWEEN ((convert(nvarchar(10), dates,110) = '2012-12-12') AND (convert(nvarchar(10), dates,110) = '2012-12-12'))
  </code></pre>
  
  <p>but doesn't seem to work. "Incorrect syntax near ="</p>
  
  <p>Please help</p>
  
  <p>EDIT:</p>
  
  <p>Thanks for various options and description guys. Got it working with @RichardTheKiwi's options.</p>