How to insert the current time field to the mysql database

How to insert the current time field to the mysql database? $ Conn-& gt; prepare (& quot; INSERTINTOaaa (name, mydate) VALUES (trim (: name), now () & quot;); this cannot be executed, how should I change it ?, No. how do I insert the current time field to the mysql database?
$ Conn-> prepare ("insert into aaa (name, mydate) VALUES (trim (: name), now ())");
This cannot be executed. how can I change it?

------ Solution --------------------
Error reported during failed execution
What type is mydate? change it to DATETIME.
------ Solution --------------------
$ Conn-> prepare ("insert into aaa (name, mydate) VALUES (trim ('name'), now ())");

In addition, if you do not know how to debug the program, you can run the SQL statement in the mysql management tool. if the SQL statement is incorrect, the system prompts you why it is incorrect, you can debug and modify it.
------ Solution --------------------
Insert into 'AAA' Set name = 'abc', mydate = '". time ()."'