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