Re: Adding a month

Posted in 1998

Rajesh_Kapur@spartanstores.com — Tue, 22 Sep 1998 12:04:49 -0400 — source: Informix-list mailing list archive (1991-1998)

try this select datum + interval(1) month to month from <table> where .... Zeljan Silje <zeljan@laus.hr> on 09/22/98 07:09:47 AM To: iiug <informix-list@iiug.org> cc: (bcc: Rajesh Kapur/CBSI/Spartan) 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 | +--------------------------+-----------------------------+