Sql clears data in different date formats

1. For example, there are two formats for records in the create_date field: 2018-10-10 09:08:07 and 2018-10-10 09-08-07

how to find out two different formats in the sql statement delete the format 2018-10-10 09-08-07

Sql
Dec.21,2021

2018-10-10 09-08-07 this format is not easy to find. Because it does not conform to the format of datetime and datestamp.

if there are only these two formats, try to look up the data in the format of 2018-10-10 09:08:07, back it up, then empty the table, and restore the backed-up data.

Ravi Shrimali

SELECT ID FROM [Table Name] WHERE (DateLog between '2017-02-16 **00:00:00.000**' and '2017-12-16 **23:59:00.999**') ORDER BY DateLog DESC
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bf260d-46382.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bf260d-46382.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?