Shulou(Shulou.com)06/01 Report--

Editor to share with you what the role of str_to_date in mysql, I believe most people do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The function of the str_to_date method in mysql: converts a string in time format into a value of type DATETIME according to the provided display format, for example, [SELECT STR_TO_DATE ('2017-01-06 recording recording% YMY% mMMI% d) AS result].

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

SELECT STR_TO_DATE ('2017-01-06 10 20 30 minutes% Ymuri% MMI% d% HV V% iRO% s') AS result

SELECT STR_TO_DATE ('2017-01-06 10 20 30 minutes% Ymuri% MMI% d') AS result2

These are all the contents of what is the role of str_to_date in mysql. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.