Since this just came up again but for the JPA Criteria API, I think we might want to be a bit more lenient on the temporal type there for Oracle: https://discourse.hibernate.org/t/how-to-use-postgres-date-trunc-via-criteriaapi-in-hibernate-6/7220/2