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 -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
