Named Queries not working org.hibernate.query.SemanticException: Could not interpret path expression 'DATETIME'

627 views Asked by At

I have one named query and in that query there is a SQL server method to convert the date.

@NamedQuery(query="SELECT a FROM Employee a WHERE a.id = :id AND (a.dob > CONVERT(DATETIME, :dob, 102)")

During migrating this to Hibernate 6,getting the following error.

org.hibernate.query.SemanticException: Could not interpret path expression 'DATETIME'
0

There are 0 answers