Re: Date Problem

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-232002-02-26 | 2002-02-27 |
2002-02-282002-02-26| 2002-02-27 | 2002-02-282002-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