Adding months to a date in PostgreSQL shows syntax error August 19, 2023 by Tarik Try something like: update salereg1 set expdate = current_date + interval '1 month' * numberofmonths;