开发者

Are there date functions available in jpql?

开发者 https://www.devze.com 2022-12-29 04:08 出处:网络
I want to write query something like :- Select u from bookmaster u order by Year(b.create开发者_如何学JAVADate),Month(b.createDate),day(b.createDate)

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

0

精彩评论

暂无评论...
验证码 换一张
取 消