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