Hi,
I am trying to use this statement in Hibernate

Query query = session.createQuery( "select count(*) from User where registrationDate = date_sub(NOW(), 24 DAY) group by DATE_FORMAT(registrationDate, '%m/%d/%y %k') " );

problem is that the Interval is not recognized. After searching the forums I believe that this type of error has occured before in hibernate with the date_add function.

This can be seen at: http://forums.hibernate.org/viewtopic.p ... t=interval

Any advice and help would be appreciated.

Thank you in advance.
Nik