Hello, I wanted to know about how operations with dates are performed in JPQL, taking into account that I use IBM I, since I really don’t know if it is possible or not implemented, I really don’t know
You can take a look at the implementation of arithmetic operations involving datetimes in any Hibernate dialect: here’s the DB2iDialect, see e.g. timestampaddPattern and timestampdiffPattern.
You can also just test how these operations are performed yourself by using Hibernate and inspecting the generated SQL.
The problem is that you make functions that do not exist in that dialect, I just checked it with what you gave me, those functions are not implemented here
I just saw that since Db2i extends Db2, it acquires the implementation of the datediff that the other one has, I had not seen the extends that it had.