DateTime Issue With MySQL 3.23

[EnergyLevel]

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 to do this with MySQL 3.23 each time I tried the default value reverted back to 00-00-00 00:00:00 and the current date/time is not recorded when records are created \????


Thanks .....

 

[guelphdad]

You want a column of type TIMESTAMP.

 

[EnergyLevel]

Actually I don't want timestamp becauase the format is different to MySQL 4.1 and higher, I may be wrong but I thought timestamp updates each time a record is modified and I only want a creation date ...