title: how to fetch data between two dates in Sql server 2008
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5125076/sql-query-to-select-dates-between-two-dates">SQL query to select dates between two dates</a>  </p>
  </blockquote>
  
  
  
  <p>how to fetch record between two dates in sql server 2008. 
         im using I-batis query</p>
  
  <p>eg.</p>
  
  <pre><code> select * from T_SETTLEMENT_TRANSACTION WHERE status='PEND' and from_date_time &gt;='2013-01-09 04:16:52.0' AND to_date_time&lt;='2013-01-09 04:16:52.0' 
  </code></pre>
  
  <p>where two columns are in datetime format in Sql server 2008</p>