sqlQuery select dates between

naimdjon · **Joined:** Wed Feb 23, 2005 10:37 am **Posts:** 29

Hi,

I am trying to do the following.

Code:

List ids=HibernateUtil.currentSession().createSQLQuery(select id as {act.actID} from activationdate act where act.act_date between to_date('14.07.2005','dd.mm.yyyy') and to_date('20.07.2005','dd.mm.yyyy')
.addEntity("act", ActID.class)
.list();

Which works fine.

Is it possible to set these dates as named parameters?

naimdjon · **Joined:** Wed Feb 23, 2005 10:37 am **Posts:** 29

one solution would be:

Code:

List ids=HibernateUtil.currentSession().createSQLQuery(select id as {act.actID} from activationdate act where act.act_date >=:fromDate and 
act.act_date<=toDate
.addEntity("act", ActID.class) 
.setCalendar("fromDate",fromInd)
.setCalendar("toDate",toInd)
.list();

Is there any other (better) way of doing that?

max · **Posted:** Thu Jun 30, 2005 9:16 am

what is the problem with the suggested one ? and why not just use "between :fromDate to :toDate" ?