Hey there. It seems that the trunc function has multiple overloads but Hibernate 6 only supports the numeric variant right now. Please create a JIRA issue for this bug.
we have recently updated our application from Spring boot 2.x to 3.x . We are facing issue with Trunc a date .
Could you please provide update on ticket which you have created on DEC 2022
Hibernate is an open source project, so you can contribute a fix for this or pay someone to do so for you if this matter is so important to you. If you don’t want that, then you’ll simply have to wait until the Hibernate team has the time to fix this.