add or subtract days from a 'date' in query

From: bubola <bubola(at)worldonline(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: add or subtract days from a 'date' in query
Date: 2000-09-23 14:42:47
Message-ID: 3.0.1.32.20000923164247.00b97100@pop.worldonline.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi all!

I'm quite new to pgsql, but I tried to read as much docs as I could, and
also tried to browse the ml archive here, without useful results until now.

So I hope you will excuse me for the following question, that I know must
appear quite tedious to the experts :))

I just need to add (or subtract) a certain number of days to a given date
(in the format yyyymmdd), but cannot find the right syntax.

I tried many ways, making a cast to date, or to timestamp, but nothing got
right
For instance, , cause I want the second date to be ten days more than the
1st, I started writing a query such as:

insert into mytable (dateA, dateB)
values
('mydateA', 'mydateA'+ 10)

but got an error msg, telling that I cannot add unknown type with int

so I made

insert into mytable (dateA, dateB)
values
('mydateA', 'mydateA'+ 10 days)

but pg did not understand what that 'days' stood for

so I tried

insert into mytable (dateA, dateB)
values
date('mydateA', 10)

and so on, but always with no result :((


Could anyone please help me?

Thanks a lot

bubola

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message D. Duccini 2000-09-23 15:11:42 Re: add or subtract days from a 'date' in query
Previous Message Paul Wehr 2000-09-23 14:08:35 Re: [SQL] how to store a query, that results in a table