Re: SE7.23: using today +- n question

Posted in 2000

Richard harnden — Fri, 03 Mar 2000 18:24:33 +0000 — source: Informix-list mailing list archive (1991-1998)

I had this problem too. Tried: INSERT ... VALUES(DATE(today - 3)) INSERT ... DATE(EXTEND(CURRENT, ... Nothing Works. (which is normal for my sql, btw :) Ended up having to insert TODAY, then: UPDATE ... SET (datum) = (datum - 3) WHERE datum = TODAY Annoying. >>> Peter <proORGA-Leimen@t-online.de> 03/03/00 02:54pm >>> Hi, using "select today - 3 from sysusers", works as expected, using "insert into A (datum) values ( today) works again, why will not work "insert into A (datum) values ( today - 3) ? Thanks for helpness Peter