to_date in mysql code example

Example 1: select STR_TO_DATE(date_seance1,'DD-MM-YYYY')

ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y')

Example 2: disallowed function mysql to_date()

SELECT STR_TO_DATE('18,05,2009','%d,%m,%Y');

Example 3: disallowed function mysql to_date()

SELECT STR_TO_DATE('21,5,2013','%d,%m,%Y');