DynamicQuery DISTINCT DATE_FORMAT

[ildar sl, modificado 8 Anos atrás.]

Hi all!

How to Query "SELECT DISTINCT DATE_FORMAT(createDate,'%Y') from blogsentry"?

DynamicQuery dq = DynamicQueryFactoryUtil.forClass(BlogsEntry.class);
dq.addOrder(OrderFactoryUtil.asc(F_CREATE_DATE));
dq.add(RestrictionsFactoryUtil.eq(F_GROUP_ID, groupId));

Projection projection = ProjectionFactoryUtil.distinct(ProjectionFactoryUtil.property(F_CREATE_DATE));
    	dq.setProjection(projection);

List<blogsentry> result = BlogsEntryLocalServiceUtil.dynamicQuery(dq);
</blogsentry>

How to write this is the place DATE_FORMAT (createDate, '% Y')?