coding a default value for a DATETIME field

Wasn't this answered yesterday? Anthony Farrell wrote: > > how do I automatically insert a datetime value into a column, > can I do it in the create table command, i.e > > create table .... > > when DATETIME YEAR TO SECOND default XXXX DATETIME YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND > > what is the XXXX, so that the column would update itself with the > currnet date > and time on an insert ???? Art S. Kagel

how do I automatically insert a datetime value into a column, can I do it in the create table command, i.e create table .... when DATETIME YEAR TO SECOND default XXXX what is the XXXX, so that the column would update itself with the currnet date and time on an insert ????