I think the problem you are experiencing is due to the format of the date you are entering. When using a timestamp type of column you should enter the date the same as it is stored in the db, like this:
YYYY-MM-DD hh:mm:ss
If you cannot insert a date using this format you should take a look at the column type in your table. If date is not working for you a timestamp type of column should be used. This will hold the date and time for you. If you have a timestamp type of column and just would like to auto default the column to store the current date and time you could set the default value of the column to CURRENT_TIMESTAMP.
