How to convert a string to a date time in format format in MySQL
Editor to share with you how to convert strings into format format date and time in MySQL, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!
STR_TO_DATE (date,format): converts a string to a date time in format format
SELECT STR_TO_DATE ('2015-01-01-01,'% YMY% mmury% d')-> 2015-01-01 is all the contents of this article entitled "how to convert a string into a date and time in format format 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!
