Geek asks and answers

Sleep Mode Criteria: NOW () <date + 1 day

I have a table in a MySQL database with a column date(DATETIME). How to express this in Hibernate java criteria if I say that I would like to request records, where NOW() < ('date' + 1 day)?

+5
source share
1 answer

You can reverse it and compare 'date' >= (NOW - 1 day).

Assuming you have a mapped class MyTablewith a property date:

Calendar c = Calendar.getInstance();
c.add(Calendar.DATE, -1); 
Criteria criteria = session.createCriteria(MyTable.class);
criteria.add(Restrictions.ge("date", c.getTime());
List results = criteria.list();
+10
source

More articles:


All Articles