Hibernate Community • View topic - Use HQL function with criteria API

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Use HQL function with criteria API

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

ojs

Post subject: Use HQL function with criteria API

Posted: Tue Nov 22, 2005 8:34 am

Newbie

Joined: Wed Jan 05, 2005 2:28 pm
Posts: 14
Location: Germany, Munich

Hello,

I have the following HQL statement:

Code:

select  a
from    A a
where   year(a.mydate) = ?

Is it possible to do the same thing with the criteria API? The problem is, that the HQL function year() seems to be not being usable with criteria restrictions.
I don't want to use database specific functions because the code wouldn't be portable anymore.

Bye
Oliver

Top

giangnh

Post subject:

Posted: Tue Nov 22, 2005 7:44 pm

Newbie

Joined: Sat Oct 30, 2004 4:00 am
Posts: 11

i met exactly same problem before!
MUST use trick:
firstDate=<first date of year>year+01+01;
lastDate=<last date of year>year+12+31;
criteria.add(Restrictions.between("propName", firstDate, lastDate));

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum