RE: Adding a month

Posted in 1998

Thomas Tatum — Tue, 22 Sep 1998 13:28:59 -0400 — source: Informix-list mailing list archive (1991-1998)

with IUS 9.14 you can do something like: theDate + interval(1) month to month > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Zeljan Silje > Sent: Tuesday, September 22, 1998 7:10 AM > To: iiug > Subject: Adding a month > > > 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 | > +--------------------------+-----------------------------+ >