V2x - row_level jpql - to_date function with -1

Support
#1

Hi,

I can use postgresql function like: function(‘to_date’, mydate, ‘YYYY-MM-DD’) … works fine.
But I would need to use the postgresql " to_date(‘mydate’,'YYYY-MM-DD) - 1 " to get the day before…

How to realize that in a row_level constraint?

KR
Roland

#3

Hi Roland,

Perhaps you need to define your own function in PostgreSQL and do the calculation in it.

Regards,
Konstantin

1 Like
#4

Hi Konstantin,

I expected something like that, because I could not find any doc with a solution in JPQL…

Thx
Roland