mysql cast 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: mysql cast to varchar
SELECT CAST(aField as UNSIGNED) from table;
-- for VARCHAR use CHAR(50), INT use UNSIGNED