Re: Adding a month

Posted in 1998

David C. Harrison — 22 Sep 1998 13:46:19 GMT — source: Informix-list mailing list archive (1991-1998)

Zeljan, > 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. SELECT (datum +1 UNITS MONTH) FROM table_name; Enjoy! -- David ______________________________________ David C. Harrison DCH Software Limited E-Mail: dch@dchsoftware.co.uk Web: http://www.dchsoftware.co.uk