In mysql, you can use the "STR_TO_DATE(str,format)" function to convert the time format string str into a DATETIME type value according to the provided display format.
Recommended: "mysql video tutorial"
STR_TO_DATE(str,format) function is to convert the time The format string (str) is converted into a DATETIME type value according to the provided display format (format). The DATE_FORMAT(date,format) function converts the date in the database into the corresponding string format. It is relatively common and will not be explained.
SELECT STR_TO_DATE('2017-01-06 10:20:30','%Y-%m-%d %H:%i:%s') AS result;
SELECT STR_TO_DATE('2017-01-06 10:20:30','%Y-%m-%d') AS result2;
The above is the detailed content of How to convert mysql str to date. For more information, please follow other related articles on the PHP Chinese website!