How to convert mysql str to date

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!