Re: calculate date

Posted in 1998

Nils Myklebust — Fri, 03 Apr 1998 16:11:56 GMT — source: Informix-list mailing list archive (1991-1998)

On Fri, 03 Apr 1998 03:17:39 -0600, jjdai@hotmail.com wrote: >hi, > Can you tell me how can I know the next month in 4gl > for example : > the value of data is 1998/03 and I want to get the result 1998/04 > or 1997/12 to 1998/01 , > is there a function to do this in sql statement RTFM on + 1 units month You get a datetime, not a date back, but 4GL should handle that. >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: Primary with ODBC info: http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html

Related threads

4gl and stored procedures