Hi there,
I have searched the forum and checked the documentation but I cant seem to find how to compare dates with literals in hql.


my database is mysql latest version
my hbm.xml file stores the type as date

select sbm from User as u inner join u.smsBoxMessages as sbm where u.id=1 and sbm.receipientMobileNumber like "%%" and sbm.date >= "2003-01-01" and sbm.date<= "2004-01-01" and sbm.message like "%%"

The date stored in mysql is "2004-06-23"

the hql compiles correctly and able to retrieve the data i want when the date sbm.date="2004-06-23" which is the same as the date in the database but it doesnt work when i try "2003-01-01" in the above hql


i am trying to get rows that are between certain dates and i want to be able to specify those dates in the hql

can anyone give me any pointers? or am i comparing the dates wrongly? if so can anyone give me an example or how i can compare dates with a custom value in hql?

Dear Dude
Why don't you use BETWEEN AND instead of >= and =<, I think this might help you. Because I'm using it.
Cheers

you mean like this?

sbm.date between "2001-01-01" and "2002-01-01"

would the "between and" be inclusive of 2001-01-01 and 2002-01-01 ?

or is there a way to specify inclusive or exclusive?

sbm.date between "2001-01-01" and "2002-01-01"
The result set from BETWEEN .... AND ..... will include "2001-01-01" and "2002-01-01". I try to map from

sbm.date >= "2003-01-01" and sbm.date<= "2004-01-01"

I think >= and <= mean inclusive start and end date into result

Cheers