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'