Episode-079 – Converting Strings to Dates in MySQL

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