Re: Function error - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: Function error
Date
Msg-id GNELIHDDFBOCMGBFGEFOAEKLCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Function error  ("Sugandha Shah" <Sugandhas@cybage.com>)
List pgsql-sql
> 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



pgsql-sql by date:

Previous
From: "Sugandha Shah"
Date:
Subject: Re: Function error
Next
From: "Alexander M. Pravking"
Date:
Subject: Re: Conversion