tags:

views:

191

answers:

0
Q: 

Are there date functions available in jpql?

Hello, 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?

related questions

JPQL to get nearest records by latitude and longitude
How to query a property of type List<String>in JPA
JPQL: InnerSelect causes PersistenceException (HibernateException: Errors in named queries)
Get Random Rows Using JPQL
translating outer join SQL query into EJB entity beans
How to get the database time with JPQL?
SELECT NEW in JPQL
Tool to Execute JPQL Queries?
JPA QL, How to NOT select something
Setting a parameter as a list for an IN expression
Execute "MEMBER OF" query against 'ElementCollection' Map fields in JP-QL (JPA 2.0)
JPQL for Entities with No Items in ManyToMany Relationship
Toplink IN subquery
JPQL and SQL Criteria Api
Compare two dates with JPA
Parameter in like clause JPQL
Select nvl(max(c.EmployeeId),0) in JPQL?
JPA createQuery with a partial composite key
JPQL and timestamp with timezone
How do I use JPQL to delete entries from a join table?
JPQL test if value is in an array
JPQL createQuery throws illegalArgumentException
How to filter collection in JPA/JPQL?
Nested JPQL queries in hibernate, are they creating nested objects?
JPA and Hibernate Fetch ignoring Associations?