Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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
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)
				('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)
				('mydateA', 'mydateA'+ 10 days)

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

so I tried

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

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

Could anyone please help me?

Thanks a lot



pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group