Issue on date_trunc HQL, as shown belwo

Hibernate ORM
1

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)
@Temporal(TemporalType.TIMESTAMP)
@Id
private Date date;

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

Line 2 :
" datetrunk(‘day’, c.date) " :

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.

2

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