Обсуждение: Add a month
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");
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: "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.