Re: Default question

Posted in 1996

Mark D. Stock — Fri, 25 Oct 1996 16:24:01 -0700 — source: Informix-list mailing list archive (1991-1998)

Steve Proctor wrote: > > Online 5.01, no manuals! > > Is this supported in my version : > > create table ... > > ... who_updated datetime year to second default current, > > It doesn't seem to like current ( or today ) for the default. > > Please reply to my email address as well as the Newsgroup. Thank You. The syntax for CURRENT is to include the precision: CREATE TABLE ... ... who_updated DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND, Strange as it may seem. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+