From: Stuart <sfbarbee@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: Date Problem
Date: Thu, 1 May 2003 05:38:40 -0400
Message-ID: <200305010538.41212.sfbarbee@yahoo.com> (raw)
In-Reply-To: <3EB10DEB.1267.564751@localhost>
References: <3EB10DEB.1267.564751@localhost>
Ramesh,
If your field is a date field, you should be able to just do (From + 1),
(From +2)....
I know this works in 7.3.2 as in my example.. where published is a date field
select published,( published + 1), (published +2) from documents limit 10;
published | ?column? | ?column?
------------+------------+------------
2002-02-21 | 2002-02-22 | 2002-02-23
2002-02-26 | 2002-02-27 | 2002-02-28
2002-02-26 | 2002-02-27 | 2002-02-28
2002-02-25 | 2002-02-26 | 2002-02-27
Hope this helps.
Stuart
On Thursday 01 May 2003 02:36, Ramesh PAtel wrote:
> Hi All
>
> now Problem is
>
> I have to date From = '2003-04-01' and To='2003-05-12'
> now i want to use use date butween From and To.
> and each date one bye one use in query. so how to
>
> i increse date one bye one
>
> Please Help me.
>
> Ramesh Patel
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
"... the Zionist state of Israel has ignored many United Nations Security
Council Resolutions; possesses nuclear weapons and other weapons of mass
destruction; is currently engaged in a genocidal programme of mass killings
of Palestinians and that no attempt has been made by the United States or
Britain to disarm Israel or to stop its genocidal mass killings of
Palestinians" -- Result of Pan African Forum on Africans and the American
Imperialist War February 23, 2003
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sfbarbee@yahoo.com
Subject: Re: Date Problem
In-Reply-To: <200305010538.41212.sfbarbee@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox