Answers for "mysql string to date"

cast string to datetime mysql

SELECT STR_TO_DATE('2017-03-13T14:39:01.123','%Y-%m-%dT%H:%i:%s.%f');

select STR_TO_DATE(date_seance1,'DD-MM-YYYY')

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

DATE_FORMAT(STR_TO_DATE

mysql> Select STR_TO_DATE('22.10.2017',GET_FORMAT(DATE,'EUR'))AS 'EUROPEAN FORMAT';
+-----------------+
| EUROPEAN FORMAT |
+-----------------+
| 2017-10-22      |
+-----------------+
1 row in set (0.00 sec)