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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
