Using the str_to_date() function in MySQL, we can convert a string that contains non-ISO formatted date data and convert it to a valid date. This video will show an example of how to use str_to_date() to convert dates in a mm/dd/yyyy format to a valid ISO date.
str_to_date() Documentation - https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_str-to-date
date_format90 Documentation for pattern matching tokens - https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_date-format
str_to_date() Documentation - https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_str-to-date
date_format90 Documentation for pattern matching tokens - https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html#function_date-format
- Category
- MySQL
- Tags
- MySQL, Database, Open-source

Be the first to comment