Episode-079 - Converting Strings to Dates in MySQL

8 Views
Published
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
Category
MySQL
Tags
MySQL, Database, Open-source
Be the first to comment