title: Select rows within a date range in T-SQL
body: <p>I have a set of rows, each with a date value, and I need to select rows that fall within a specific date range. How can I do this?</p>
  
  <pre><code>select * from table where convert(int,date_created) between //what should go here?
  </code></pre>
  
  <p>I want to select between <code>'20-10-2010'</code>  and <code>'22-10-2010'</code>.</p>
  
  <p>It keeps complaining about string to date conversion.</p>