Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL Date Query

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

lenzenc

Post subject: HQL Date Query

Posted: Fri Mar 10, 2006 10:46 pm

Newbie

Joined: Tue Sep 21, 2004 1:33 pm
Posts: 5

I'm looking for help in writing an HQL query that finds all objects that equal today's date or greater given an objects date property.

This seems pretty straight forward but I can't seem to find a good example.

I'm using Hibernate 3.1.2 and MySql 4.

Top

simonwillnauer

Post subject:

Posted: Sat Mar 11, 2006 8:00 am

Regular

Joined: Tue Mar 07, 2006 11:18 am
Posts: 54
Location: Berlin

Does every Entity has got a date Property?

So lets say you have a couple of entities in the same class hierarchy all of them have these "date" Property you could do a simple criteria query like:

Code:

Criteria criteria = session.createCriteria(Father.class);
criteria.add(Restrictions.or(Restrictions.ge("date",new Date()),Restrictions.ge("date",otherDate));

simon

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