I want to write query something like :-
Select u from bookmaster u order by Year(b.create开发者_如何学JAVADate),Month(b.createDate),day(b.createDate)
How do i do this in JPQL? Are there any date parsing functions available?
Well Brandizzi, theese function are in your list, but checked as 'not standard' I've tried use them without success.
Here is an alternative: JPA Query MONTH/YEAR functions
精彩评论