[SLUG] fustrations with mysql (TIMESTAMP)

[Michael Fox <michael@xxxxxxxxxx>]

Afternoon,

I've been trying (keyword trying) to attempt to use a field in mysql to record 
the time at which a record is created in a table.

ie;

-- snip --
created TIMESTAMP(14) default NULL,
-- snip --

However when I submit my data into the table/fields, without success I can 
never get the field "created" to have the timestamp 'YYYYMMDDHHMMSS' at which 
it was entered.

ie.
-- snip --
INSERT INTO blah VALUES( 'blah','blah','');
-- snip --

I've tried '', '\n' and 'NOW()' all without success.

Can anyone put me out of my misery and solve this for me, as I've read and 
read yet still can't get something to work.

Thanks