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 - File online, calculators, forms, and more