[eluser]TheFuzzy0ne[/eluser]
A date and time field (in MySQL, anyway), requires a string in the correct formats, and it's not possible to pass it a timestamp. You can format your timestamp using date(), and then everything should work. You should see this working if you query the database with something like:
INSERT INTO `table_name` ('my_column') VALUES('NOW()');