I need to write a query that is something like this:
select data from Object data where data.createDate + 30days < current_date()

Is there a way to create an expression like this (data.createDate + 30days) with hql?

thanks!

You should be able to execute it using the following:
select c.* from <Class> c where (c.createDate + 30) < current_date()
or you can simply use the DB specific date function like addDays() or something in that terms in your hql.. ex:
select c.* from <Class> c where addDays(c.createDate, 30) < current_date()
Hope that helps.
- Arun

I tried this but it doesn't work. I want a way to do this that is database independent. BUt it seems like hibernate doesn't have any built in date functions to accomodate

I was looking for something along these lines, Would this work for you?

DateTime dt = DateTime.Today.addDays(-30);
IQuery qry = session.CreateQuery("select data from object where data.CreateDate < :date");
qry.SetDateTime(dt);
IList list = qry.List();

Murthy