掲示板
DynamicQuery DISTINCT DATE_FORMAT
7年前 に ildar sl によって更新されました。
DynamicQuery DISTINCT DATE_FORMAT
Regular Member 投稿: 158 参加年月日: 11/12/12 最新の投稿
Hi all!
How to Query "SELECT DISTINCT DATE_FORMAT(createDate,'%Y') from blogsentry"?
How to write this is the place DATE_FORMAT (createDate, '% Y')?
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')?