How to add a number from a column to a date in postgres

Question

I am trying to do something like this

select myDate+addDays from myTable

myDate is a datetime column in the table addDays is an integer column in the table

select current_timestamp + interval '1' day * add_days_count from myTable — Ankur Srivastava
– Ankur Srivastava, Commented Jun 15, 2018 at 1:55
Does this answer your question? In a postgresql select, add a timestamp column to an additional_days column — user330315
– user330315, Commented Apr 16, 2021 at 14:03

Tushar R. · Accepted Answer · 2021-04-16 12:11:28Z

2

select myDate + (interval '1' day * addDays) from myTable

Above query will work on PostgreSQL as well as Oracle.

answered Apr 16, 2021 at 12:11

Tushar R.

3183 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1