Problems storing in a INTERVAL DAY(9) TO DAY field

Try the following: create table test(id serial, dd INTERVAL DAY(9) TO DAY); insert into test values(0, INTERVAL(99) DAY TO DAY); insert into test values(0, INTERVAL(100) DAY TO DAY); -- this onegives a syntax error why can't I store a 3-digit amount of days?, shouldn't I be able to store a 9-digit amount of days at most?

Gerardo Santana wrote: > Try the following: > > > create table test(id serial, dd INTERVAL DAY(9) TO DAY); > insert into test values(0, INTERVAL(99) DAY TO DAY); > insert into test values(0, INTERVAL(100) DAY TO DAY); -- this one> gives a syntax error > > why can't I store a 3-digit amount of days?, shouldn't I be able to > store a 9-digit amount of days at most? > You can store 9 digit days, but your insert statement can only handle 2 digits. Try: insert into test values(0, INTERVAL(100) DAY(9) TO DAY); Art S. Kagel Oninit > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > >