How to add number of days to a date field in postgresql

Question

I have a date field in a table named product. I need to add some days to this field how to d this. I am new to PostgreSQL.

I tried this:

select manufacture_dt + weeks*7 from product;

It is giving me the error

operator does not exist: timestamp without time zone + integer.
Hint no operator matches the given name and argument types .you might need to add  explicit type cast

Laurenz Albe · Accepted Answer · 2021-04-15 08:07:45Z

4

There is no + operator for timestamp and integer, but there is one for timestamp and interval. Moreover, intervals can be multiplied with numbers.

So you could write:

SELECT manufacture_dt + weeks * INTERVAL '7 days'
FROM product;

The syntax DATATYPE 'somevalue' is SQL syntax for a constant (literal) of a certain data type.

answered Apr 15, 2021 at 8:07

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

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

Comments

Pravash Panigrahi · Accepted Answer · 2021-04-15 08:23:11Z

0

Assuming 'weeks' is a column containing number of days in integer in that table 'product', If you want to multiply 'weeks' columns value with the 'manufacture_dt' column you can try below query :-

select
       manufacture_dt + interval '7 day' * weeks as new_date
from product

https://www.postgresql.org/docs/current/functions-datetime.html

answered Apr 15, 2021 at 8:23

Pravash Panigrahi

7122 gold badges9 silver badges24 bronze badges

Comments

user330315 · Accepted Answer · 2021-04-15 08:09:26Z

0

You don't have a date column, you have a timestamp column.

You can only add an interval to a timestamp value

If weeks is another column in your table, you can use make_interval to generated the interval

select manufacture_dt + make_interval(weeks => weeks::int)
from product;

answered Apr 15, 2021 at 8:09

user330315

Collectives™ on Stack Overflow

How to add number of days to a date field in postgresql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related