mysql convert string to date code example
Example 1: cast string to datetime mysql
SELECT STR_TO_DATE('2017-03-13T14:39:01.123','%Y-%m-%dT%H:%i:%s.%f');Example 2: str_to_date sql server
SELECT STR_TO_DATE('17-09-2010','%d-%m-%Y');SELECT STR_TO_DATE('2017-03-13T14:39:01.123','%Y-%m-%dT%H:%i:%s.%f');SELECT STR_TO_DATE('17-09-2010','%d-%m-%Y');