Скачать или смотреть INSERTING PHP Current Date and time to MySQL table using YYYY-mm-dd format and using STR_TO_DATE()

https://www.plus2net.com/sql_tutorial...
https://www.plus2net.com/php_tutorial...
https://www.plus2net.com/sql_tutorial...

We have to format our date or date and time input to match MySQL required format. MySQL database date and date and time column accepts data in YYYY-mm-dd and YYYY-mm-dd H:i:s formats only
We will use one input query and use the variables having data in MySQL required format to store in MySQL table.
INSERT INTO dt_tb (dt,dt2) VALUES ('2004-05-05 23:56:25', '2005-06-12');
MySQL date field will accept only valid dates and times so proper formatting is a must and we will discuss here how a record with a date field and a date and time field is added to a mysql table. We have one date field and one date time field in our table so we will try to format for both the fields. Here are the formats.

WE will use current date and time to add to our table.
First in two variables we will store date and time.
$dt1=date("Y-m-d");
$dt2=date("Y-m-d H:i:s");

#INSERTDATE, #DATEINSERT, #PDODATEINSERT