Good morning!

I am using nHibernate to persist an object that contains a property of the DateTime type and I use to build a query to select them. Can anyone of you tell me whether it is possible to compare an incoming string (contains a date typed in by the user) and the DateTime values saved in my database table using a LIKE statement?

I already tried statements like " where Date LIKE '*<value>*' " or " where Date LIKE '%<value>%' "...
Every query was executed by nHibernate. No errors... But there were no results.

Is it just a simple mistake in my statement or isn't it possible to compare DateTime's and strings with LIKE?

I thank you very much in advance.

Monty

Isntead of doing this in HQL you can use the "Expression.like()" in the "org.hibernate.criterion" package instead.

I made it... still using HQL...

I changed the type of the incoming value to object (value is something like "26.07.2006 00:00:01") and compare the values stored in my database table like this:

where Date >= value AND Date < value + 1 day

and it works fine.

But I thank you very much anyway... :-)

hi pals!!!

This is a way to do LIKE in a hql query..

Query q = em.createQuery("select new s from Student as s where s.name like :x");
q.setParameter("x",name+"%");

Notice that here I'm using EntityManager, but the same idea also works for Session, but the method to set the variable "x" is setString, if I'm not wrong

I don't know if it'll help, but there it is...