Search code examples
javamysqlcriteriahibernate-criteria

Change date format criteria query in hibernate?

I am displaying my test name and date by using below query. Now my date format is 2014-02-27 17:26:49.0 but i need to display in 2014-02-27 format. How can i modify my query for this?

Session ses = sessionFactory.getCurentSession();
Criteria c = ses.createCriteria(user.class);
c.add(Restrictions.eq("id", uid));
c.add(Restrictions.eq("name", uname));

ProjectionList pl = Projections.projectionList();
pl.add(Projections.property("testid"));
pl.add(Projections.property("date"));

c.setProjection(Projections.distinct(pl));
List<String> list = c.list();
Solution 
  • By using "sqlGroupProjection" I have changed my date format to **2014-02-27**

projectionList.add(Projections.sqlGroupProjection("date(date) as createdDate", "createdDate", new String[] { "createdDate" }, new Type[] { StandardBasicTypes.DATE }));