What is the use of str_to_date method in mysql

The function of the str_to_date method in mysql: convert the time format string into a DATETIME type value according to the provided display format, such as [SELECT STR_TO_DATE('2017-01-06','%Y- %m-%d) AS result].

The STR_TO_DATE(str,format) function converts the time format string (str) into the DATETIME type according to the provided display format (format) value.

(Recommended tutorial:mysql video tutorial)

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;

phptraining

The above is the detailed content of What is the use of str_to_date method in mysql. For more information, please follow other related articles on the PHP Chinese website!