if your data filed in your table is date like that 000-000-00 or dd-mm-yyyy
you have to use CURDATE() in your mysql query
if your data filed in your table is int(10) in example you have to use the php time() function like that:

insert into `table_name` set `time` = \'\".time().\"\'

and you have to use date() function also