Very Computer

didn't > work either. > > Thanks for any light anyone can shed on this. > >

Troy,

Try this:
        time_stamp DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO
SECOND NOT NULL

It will work.  It seems strange that this should be essential -
generally in the manuals there is a lot of discussion about how the bits
of a DATETIME or EXTEND() that are left out are defaulted, and  how
additional precision is just truncated.  But in the CREATE TABLE
statement, it seems necessary to be this explicit.

Hope that helps

RET

     Troy

     Try

     time_stamp DATETIME YEAR TO SECOND CURRENT YEAR TO SECOND NOT NULL;

     HTH

     Sujit

______________________________ Reply Separator _________________________________
Subject: Datetime Defaults

Date:    8/22/98 3:00 PM

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.