Are there date functions available in jpql?

Question

I want to write query something like :-

Select u from bookmaster u order by Year(b.createDate),Month(b.createDate),day(b.createDate) 

How do i do this in JPQL? Are there any date parsing functions available?

Answer 1

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