query for retrieving entities between the given dates

prashanth.to · **Joined:** Thu Aug 10, 2006 3:03 am **Posts:** 1

I have taken a property 'hiredate' as java.util.Date in the javabean

and mapped to the column hiredate(date) in MySQL database

now i want to generate a query for retrieving the entities between the range of dates

note: date format choosen is 'yyyy-mm-dd'

awaiting the response from u my friend

pepelnm · **Posted:** Thu Aug 10, 2006 8:43 am

Are you asking for something like this?

Code:

Date start = something;
Date end = otherthing;
String hql = "from classname x where :startDate <= x.hiredate and x.hiredate <= :endDate";
List items = Session().createQuery(hql)
   .setDate("startDate", start)
   .setDate("endDate", end)
   .list();

Don't forget to rate me if I helped you.