title: Rails ActiveRecord - how to fetch records between two dates
body: <p>I have two date columns - <code>from_date</code> and <code>to_date</code> in a database table.</p>
  <p>Example:</p>
  <ul>
  <li><code>from_date</code>: <strong>2012-09-10</strong></li>
  <li><code>to_date</code>: <strong>2012-09-30</strong></li>
  <li><code>today</code>: <strong>2012-09-13</strong></li>
  </ul>
  <p>I need to fetch all records, if <code>today</code>'s date is between <code>from_date</code> and <code>to_date</code>. How do I do that with a SQL query?</p>
  <p>If I have loaded the respective record, I can easily decide, if today's date is between <code>from_date</code> and <code>to_date</code>, but I don't know how to fetch those records straight from the database table.</p>