string to date mysql format code example
Example 1: select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y')Example 2: str_to_date sql server
SELECT STR_TO_DATE('17-09-2010','%d-%m-%Y');ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y')SELECT STR_TO_DATE('17-09-2010','%d-%m-%Y');