How to convert varchar2 to date in sql or mysqlYou can simply use the date_format() to convert from varchar2 to date. Syntex SELECT DATE_FORMAT(STR_TO_DATE(fieldName, '%D-%M-%Y'), '%Y%m') as DateFormat from tableName; OR select date_format(str_to_date('01/01/2021',...