how do I add a default timestamp to a table

> ... > TIMESTAMP DATETIME YEAR TO SECOND default "XXXXX", > > what do I need to replace the "XXXXX" with "XXXXX" should be CURRENT YEAR to SECOND, doesn't it ? Chris

current year to second Anthony Farrell wrote: > when creating a table in the "create table" script > how do I automatically add the current date and time to a column, > > create table XX(> ... > TIMESTAMP DATETIME YEAR TO SECOND default "XXXXX", > ) > > what do I need to replace the "XXXXX" with

when creating a table in the "create table" script how do I automatically add the current date and time to a column, create table XX(... TIMESTAMP DATETIME YEAR TO SECOND default "XXXXX", ) what do I need to replace the "XXXXX" with