Add a month

Поиск
Список
Период
Сортировка
Искать

Add a month

От:
"Gaetano Mendola" <mendola@bigfoot.com>
Дата:
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 
#include 
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");

Re: Add a month

От:
"Gaetano Mendola" <mendola@bigfoot.com>
Дата:
From: "Rajesh Kumar Mallah." 
> 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.

Re: Add a month

От:
"Rajesh Kumar Mallah." <mallah@trade-india.com>
Дата:

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.
FAQ