Meaningless Drivel is fun!*
The moose likes Object Relational Mapping and the fly likes Restrictions Between for Date in Hibernate Criteria Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Restrictions Between for Date in Hibernate Criteria" Watch "Restrictions Between for Date in Hibernate Criteria" New topic
Author

Restrictions Between for Date in Hibernate Criteria

SanjayR Jain
Ranch Hand

Joined: Mar 05, 2009
Posts: 43
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 & lower limits.
My code is like below

My starting date is 25/11/2010. and end date is 25/05/2011.But it is only giving the result up to 24/05/2011.It is not performing inclusive search.Any other way to do this.
I am using SQL server.
Please help
Thanks in advance.
 
wood burning stoves
 
subject: Restrictions Between for Date in Hibernate Criteria
 
Similar Threads
adding or in criteria query
Audited tables
Problem with the <set> mapping please help
Stumped on my SimpleDateFormat issue
Generate date in 2011-04-26T16:52:57-05:00 format.