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
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 |