'postgresql mybatis date format?

Please tell me how to change the calculation method of this format

before is feasible

now() + interval '3' month  as end_date

after not executable

now() + interval #{value} month  as end_date

please..

Success Thank you all for your help! now() + make_interval(months => #{value}::integer) as end_date



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source