I'm trying to use datetime with a MySQL 3.23 DB to record the date that each record is created, I've tried creating a table using
`date` datetime NOT NULL default 'NOW()',
`date` datetime NOT NULL default 'CURRENT_DATE',
`date` datetime NOT NULL default 'CURRENT_TIMESTAMP',
Anyone an idea how...