SQL : Select record by passing a date within the range <p>I have table Structure like this</p> <pre><code>id from to 1 2014-02-01 00:00:00 2014-02-28 00:00:00 2 2014-01-01 00:00:00 2014-01-30 00:00:00 3 2014-03-01 00:00:00 2014-03-30 00:00:00 </code></pre> <p>and There is no date range overlapping in this</p> <p>I'm trying to select record by passing a date which lie within the range</p> <p>eg. passing date <code>'2014-01-16'</code> should return the record with <code>id=2</code> as it falls within the range of the dates in this row, please guide me to solve this.</p> <p>Thanks in advance</p>