add or subtract days from a 'date' in query
От | bubola |
---|---|
Тема | add or subtract days from a 'date' in query |
Дата | |
Msg-id | 3.0.1.32.20000923164247.00b97100@pop.worldonline.it обсуждение исходный текст |
Ответы |
Re: add or subtract days from a 'date' in query
|
Список | 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
В списке pgsql-novice по дате отправления: