How to recognize the date and automatically add it to the Wordpress calendar?

Question

MySQL

There is an automatic data import in Wordpress + Woocommerce.
Import into product attribute named "date".
Data is written to it in the form of a date, but different products have a different format for this date, and somewhere the time is added - 06/24/2017, 02/03/2018 14:30:00, 2017-11-21 19:00: 00, 2017-04-07T01:00:00Z.
How to recognize different date formats, cut off all unnecessary and enter this data into the calendar, so that later you can sort products by date? This is real?

Answer 1

php.net/manual/en/function.strtotime.php