Year, month, and day of hibernate computing

The Date Field of the database table contains the year, month, day, hour, minute, and second, but we may only make some statistics, such as statistics by day and by month, according to some posts found and official hibernate documents, the general method is as follows: Hibernate provides second (), minute (), hour (), day (), month (), year () and other methods can be directly used in HQL statements. Assume that a table RECORD records the payment log. The related fields are REC_COST and REC_DATE. The REC_DATE contains the year, month, day, hour, and minute, and the corresponding object is RecordModel. The daily total payment is calculated by day, hql is as follows: select year (r. recDate), month (r. recDate), day (r. recDate), sum (r. cost) from RecordModel as r group by year (r. recDate), month (r. recDate), day (r. recDate.