The following article describes how to insert data to the datetime type of MySQL using php. To insert data to the datetime type of MySQL using php, you only need to perform proper operations, the following articles provide you with the correct solutions.
We need to use the datatime type today. The original string format is 03/26/10 18:00:00.
I am used to php's conciseness and directly use strtotime, So I thought mysql would automatically handle it and the result was not.
Then copy a format from the php manual:
Date ("F j, Y, g: I a", strtotime ($ srcDataStr) format, still invalid. It is found that MySQL is retrieved and displayed in 'yyyy-MM-DD HH: MM: ss' format. Therefore
Date ("Y-m-d H: I: s", strtotime ($ srcDataStr) inserts data smoothly.
The above content describes how to use php to insert data to the MySQL datetime type. I hope it will help you in this regard.