Re:

To increment days:

SELECT cast(now() + interval '10 day' as date);

Otherwise I suggest you take a look at
http://www.postgresql.com/docs/view.php?version=7.3&idoc=1&file=functions-datetime.html

apratim sharma wrote:

> hi,
>
> Can anybody tell how to add an integer to a date inside postgres query.
>
> i'm using postgres 7.3
>
> when i give select cast(now() as date) it gives the current date,
> now i want to select a date say after 10 days.
> i'm giving select cast(now() as date) +10 ; it gives error can't
> typecast date to int
>
> what to do???
>
> please help me
>
> Apratim
>
>
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center
> <http://us.rd.yahoo.com/finance/mailsig/*http://tax.yahoo.com> - File
> online, calculators, forms, and more