> Hi ,
>
> Thanx a lot it worked .
>
> Is there any equivalent of dateadd function in postgres ?
I highly recommend you actually read the Postgres manual's entries on date
and time manipulation.
You can just add intervals to dates:
SELECT datefield + INTERVAL '1 month';
Chris