Thread: Add a month

Add a month

From
"Gaetano Mendola"
Date:
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

--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");


Re: Add a month

From
"Rajesh Kumar Mallah."
Date:
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.



Re: Add a month

From
"Gaetano Mendola"
Date:
From: "Rajesh Kumar Mallah." <mallah@trade-india.com>
> Hi the answer is:
>
> select now() + cast  ( '1 day' as interval ) ;

I guess that for me should be enough

cast ('1 month' as interval)
or may be after RTFM

should be also good

select now() + interval '1 month';

> are you reading  manuals ??

of course before to ask I give a look at manuals
but I was looking:

paragraph 3.5 and Appendix A of User's Guide  ===> nothing

after searching 'cast' on all document I find that was on
paragraph 4.8 my answer but may was good put a
link from 3.5 to 4.8 ?

Ciao
Gaetano.