title: How to get records between same date in SQL Server
body: <p>When I define a "from" and "to" date to be the same value, the query is not returning any rows. When I select an extra day for the "to" date, then rows are returned.</p>
  
  <pre><code>string FrmDt = frmtx.Text.Trim();// 9/1/2015
  string ToDt = totx.Text.Trim();//9/1/2015
  
  select 
      rn.*,
      (select count(reue) as RequtNo 
       from tblests 
       left join aspne u on r.custorid = u.userid 
       left join aspnethip a on  u.Used=a.UserId
       where 
           u.refere = rn.refid 
           and r.Compy = 'bbb' 
           and create &gt;= '9/1/2015'
           and create &lt;= '9/1/2015') as refcount 
  from 
      tbl_reference rn
  </code></pre>
  
  <p>Datatype: <code>[Createte] [datime] NOT NULL</code></p>
  
  <p>How to convert 9/1/2015 12:00:00 AM to 9/1/2015 11:59:59 PM ?</p>