> work either.
> > Thanks for any light anyone can shed on 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