Re: calculate date

Posted in 1998

Leonard Vovk — 3 Apr 1998 12:23:09 -0500 — source: Informix-list mailing list archive (1991-1998)

In article <6g29fi$55n$1@nnrp1.dejanews.com>, jjdai@hotmail.com writes: > 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 > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading Try something like this: select year(today + interval (1) month to month)*100+ month(today + interval (1) month to month) from table HTH