Re: Adding a month

Posted in 1998

Woodall Con — Tue, 22 Sep 1998 08:43:55 -0600 (MDT) — source: Informix-list mailing list archive (1991-1998)

Try select datum + 1 units month Good luck Con Woodall Colorado State University Veterinary Teaching Hospital cwoodall@vth.colostate.edu 970-491-1244 On Tue, 22 Sep 1998, Zeljan Silje wrote: > Hi, > > I have a column datum (date type) in table. I would like to find a date > one month later. So I would like my result to be: > datum datum + 1 month > 1998-1-17 1998-2-17 > > I have tried with extend, but no luck. > > Thanks in advance. > > +--------------------------------------------------------+ > | CC Computer Consulting d.o.o. | > +--------------------------+-----------------------------+ > | Zeljan Silje | e-mail: zeljan@laus.hr | > | CC Computer Consulting | Tel: +385 (20) 411-136 | > | Janjevska 15 | +385 (1) 6552-330 | > | 20 000 Dubrovnik | Fax: +385 (20) 411-136 | > | Hrvatska (Croatia) | URL: http://www.laus.hr | > +--------------------------+-----------------------------+ >