Month function in Informix?

Posted in 1999

Michael O'Sullivan — Tue, 23 Nov 1999 17:40:07 -0000 — source: Informix-list mailing list archive (1991-1998)

Hi folks, Is there a function in Informix similar to 'Add_Months()' in Oracle that simply adds to the month field in a date. Eg: Add_Months('15/07/1999', 1) = '15/08/1999' Thanks, Michael.

↪ replying to Michael O'Sullivan

GC — Wed, 15 Dec 1999 04:45:57 -0500 — source: Informix-list mailing list archive (1991-1998)

Michael, Look at the extend and interval functions. Take Care, Graeme Michael O'Sullivan wrote: > Hi folks, > > Is there a function in Informix similar to 'Add_Months()' in Oracle that > simply adds to the month field in a date. > > Eg: Add_Months('15/07/1999', 1) = '15/08/1999' > > Thanks, > Michael.

↪ replying to Michael O'Sullivan

Antonio Salerno — Mon, 20 Dec 1999 21:49:19 GMT — source: Informix-list mailing list archive (1991-1998)

How about: date_field + 1 UNITS MONTH Tony In article <81ejg9$olu$1@ezekiel.eunet.ie>, "Michael O'Sullivan" <MichaelOS@peregrine.ie> wrote: > Hi folks, > > Is there a function in Informix similar to 'Add_Months()' in Oracle that > simply adds to the month field in a date. > > Eg: Add_Months('15/07/1999', 1) = '15/08/1999' > > Thanks, > Michael. -- -- The opinions expressed here are mine and only mine. asalerno@my-deja.com http://www.summitdata.com http://www.virtual-dba.com Sent via Deja.com http://www.deja.com/ Before you buy.