Datetime Defaults

Posted in 1998

Troy Peterson — Sat, 22 Aug 1998 15:00:56 -0700 — source: Informix-list mailing list archive (1991-1998)

In dbaccess I get a "591: Invalid default value for column/variable (time_stamp)" when I try to create a field in my table as follows: time_stamp DATETIME YEAR TO SECOND DEFAULT CURRENT NOT NULL Why is it balking at the use of "CURRENT"? I tried "TODAY" but it didn't work either. Thanks for any light anyone can shed on this.