Re: insert current + 3 units second

From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > >"Ousmanov (Julia)" wrote: > > > > I have some troubles writing possibly very simple statement: > > > > INSERT INTO sb_cache (cmd, tstamp) VALUES("test cmd", CURRENT + 5 UNITS> > SECOND); > > > > table sb_cache: > > cmd - char32 > > tstamp - datetime year to fraction(3) > > > > We use Informix 7.22 and 9.21 and I need this statement to work on both > > of them. > >AFAIK the INSERT statement is not capable of performing arithmetic >operations. You will have to perform these first and then supply the >resultant value to the INSERT statement. Oh? create table obnox (col1 int); insert into obnox values (5+5); Table created. 1 row(s) inserted. I must be doing something wrong then. :-) _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com