MySQL Time date datetime field Save date appears 0000-00-00

The correct PHP SQL statement should be written as:

The code is as follows	Copy Code
$sql = "INSERT into table (datetime) VALUES ('". Date ("Y-m-d h:i:s", Time ()). The DateTime field is of type DateTime,

Note that the data you want to insert later is a string with "single quotes."
That's right, the time date type is formatted before it is inserted into the database, otherwise it's all about the 0000-00-00 problem.

Personal build justice, it's best to save time using the int type to save the date generated by this is more convenient.