How to add days to a date in PostgreSQL? I have two tables and I want to execute an update similar to this:

UPDATE table1 set table1.date = table2.date + table2.numberOfDays
FROM tabel2
WHERE table1.id = table2.table1_id


Edit: table1.date and table2.date is a date and table2.numberOfDays is a integer
I found the following solution

UPDATE table1 set table1.date = (table2.date + (table2.numberOfDays || 'day')::INTERVAL)
FROM tabel2
WHERE table1.id = table2.table1_id


OR

UPDATE table1 set table1.date = table2.date + make_interval(days =&gt; table2.numberOfDays)
FROM tabel2
WHERE table1.id = table2.table1_id