Hello. In expression 'CAST(entity.date AS date)' the datatype 'date' is conflicting with column name 'date'. I have same issue in 3.6.*.

Cause
The query is ""select a from Content a where cast(a.date as date)=?""
where
@Column(name = "C_DATE")
@Temporal(TemporalType.TIMESTAMP)
private Date date;

org.hibernate.dialect.function.CastFunction

63: final int[] sqlTypeCodes = factory.getTypeResolver().heuristicType( type ).sqlTypes( factory );
the 'date' typename is replaced with dereferenced 'date' DB column name. In my case it is 'content0_.C_DATE'