title: Restrictions Between for Date in Hibernate Criteria
body: <p>Hello I am using hibernate in my example.For bean Table Audit Trial I want to fetch audit trial between a date range with inclusion of upper &amp; lower limits.
  My code is like below</p>
  
  <pre><code>Criteria criteria = session.createCriteria(AuditTrail.class);
  
  criteria.add(Restrictions.between("auditDate", sDate, eDate));
  </code></pre>
  
  <p>My starting date is <code>25/11/2010</code>. and end date is <code>25/05/2011</code>.But it is only giving the result up to <code>24/05/2011</code>.It is not performing inclusive search.Any other way to do this.
  I am using SQL server.</p>