lundi 23 février 2015

How to convert this sql query to hibernate query

In my project i want to get the newly registered users(Registered in last 24 hrs) list. The below query works fine in SQLyog, but giving error in hibernate.. Please help me



Query q1=sessionFactory.getCurrentSession()
.createQuery("Select userID, firstName, lastName, address1, address2, city, state, " +
"zipCode, email, phoneNumber, registeredBy, pinStatus FROM User " +
"where accountStartDate > DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 DAY)");
List usersList=q1.list();

Aucun commentaire:

Enregistrer un commentaire