MYSQL - Select with Data Column Formatted with Convert

Question

I have the table(tbl) with the following field

id, date

date is a varchar field, which has dates in the following format: "dd/mm/yyyy"

I want to make a SELECT, date shown in ANSI format "yyyy-mm-dd".

I thought the following official instruction, but not:

SELECT CONVERT(datetime, date, 103) FROM tbl

Answer 1

Need to treat as string, similar to:

SELECT STR_TO_DATE(date, '%d/%m/%Y') AS data FROM tbl

Origin: Mysql date format DD/MM/YYYY select query?