JPA - grouping by date part (as in t-sql datepart)
hello, everyone.
I use JPA with Hibernate and need to group record (which has datetime field) by month and year.
In T-SQL it would look like:
select count(*) as ccc ,datepart(month , XM_DATE_CREATED) as mmm,datepart(year , XM_DATE_CREATED) as yyy from XT_SHOP_ORDER group by datepart(month , XM_DATE_CREATED),datepart(year , XM_DATE_CREATED) order by yyy,mmm
But how to do the same in JPA query language?