| From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
|---|---|
| To: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Add a month |
| Date: | 2002-05-07 07:46:42 |
| Message-ID: | 200205071316.42997.mallah@trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi the answer is:
select now() + cast ( '1 day' as interval ) ;
are you reading manuals ??
regds
mallah.
On Tuesday 07 May 2002 12:59 pm, Gaetano Mendola wrote:
> Hi all,
>
> giving a date how can I add a month ?
> Till now I was working adding x days like this
>
> now() + x
>
> but is not anymore enough
>
> Ciao
> Gaetano
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2002-05-07 08:56:24 | Re: Add a month |
| Previous Message | Jean-Paul ARGUDO | 2002-05-07 07:46:18 | Re: [DOCS] Migrating Oracle to PostgreSQL |