Re: How to select date + 1 month ?

->From: ado@ibg1.gtn.com (Christoph Adomeit) ->Subject: How to select date + 1 month ? ->Date: Mon, 16 Aug 1993 14:51:41 GMT ->Reply-To: ado@ibg1.gtn.com (Christoph Adomeit) ->Organization: ibg -> ->Hi, -> ->I wonder if there is any way to directly select a date + xx month from an ->informix sql-table. -> ->I could select a "16.8.1993" + 30 from anytable which adds 30 days to the date, ->but is there also a way to do this with month's or years ? -> ->This would be much easier than programming lots of date routines. -> ->Thanks -> Christoph ->-- ->Origin: It's not a bug, it's a feature ! Some time ago there was a fairly lengthy thread in this forum on month arithmetic. It dealt with all sorts of hard issues like: what does "Jan 30 + 1 month" mean? As it turns out, Informix does not directly support month arithmetic, probably because day arithmetic is much less ambiguous and does most of what you want. I believe Cathy Kipp of Colorado State University Veterinary Teaching Hospital has written her own month arithmetic routines in 4GL. Her email address is ckipp@vth1.vth.colostate.edu Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, Tech Ops | / \\ alan@den.mmc.com | P.O. Box 179, M/S 5422 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\