command–>
update h1b_data set RECEIVED_DATE = str_to_date(RECEIVED_DATE, "%d%m%Y");
#here, h1b_data is table name and RECEIVED_DATE is column name.
trying to update the date-format according to the MySQL’s original format.
but getting (Error Code: 1411. Incorrect datetime value: ’26-09-2021′ for function str_to_date )as result
New contributor
Anushri Dambaye is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.