RE: Automatically adding the date to a record.

2001-10-28 Thread Carsten H. Pedersen
> Hello > > Whats the easiest way to automatically add the current date to a record > whenever a new record is inserted? I have tried > CREATE TABLE > TimeStamp DATE NOT NULL DEFAULT 'DATE()' > ...); > But this doesn't work. I have tried with TIMESTAMP type instead and > this too doe

Automatically adding the date to a record.

2001-10-28 Thread David Ayliffe
Hello Whats the easiest way to automatically add the current date to a record whenever a new record is inserted? I have tried CREATE TABLE TimeStamp DATE NOT NULL DEFAULT 'DATE()' ...); But this doesn't work. I have tried with TIMESTAMP type instead and this too doesn't work I just g