Issue on date_trunc HQL, as shown belwo

HI All,

Can any one please help me on - date_trunc

what is the modiifcaiton done - we are migrating to - <hibernate.version>6.2.0.CR4</hibernate.version>

Our code is not working as expected

String timeFormat = yyyy-mm-dd;

(DB column)
private Date date;

Line 1 :
to_char(date_trunc(‘%1$s’,, :timeFormat) as period, " :

Line 2 :
" datetrunk(‘day’, " :

org.postgresql.util.PSQLException: ERROR: function datetrunk(unknown, bigint) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.

It seems datetrunk is some sort of function that you defined yourself? The function in PostgreSQL is called date_trunc and is standardized in HQL under the name truncate/trunc: Hibernate ORM 6.2.0.Final User Guide