Check out example codes for "disallowed function mysql to_date()". It will help you in understanding the concepts better.

Code Example 1

mysql> Select * from date_testing1;
+-------+------------+
| Name | Date        |
+-------+------------+
| Ram   | 2017-05-03 |
| Shyam | 2003-10-31 |
+-------+------------+
2 rows in set (0.07 sec)

mysql> Select Name, Date, DATE_FORMAT(date,GET_FORMAT(date,'USA'))AS 'DATE IN US FORMAT'from date_testing1 Where Name='Ram';
+------+------------+-------------------+
| Name | Date       | DATE IN US FORMAT |
+------+------------+-------------------+
| Ram | 2017-05-03  | 05.03.2017        |
+------+------------+-------------------+
1 row in set (0.00 sec)

Code Example 2

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)

Code Example 3

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

Code Example 4

mysql> SELECT STR_TO_DATE('18,05,2009','%d,%m,%Y');
+--------------------------------------+
| STR_TO_DATE('18,05,2009','%d,%m,%Y') |
+--------------------------------------+
| 2009-05-18                           | 
+--------------------------------------+
1 row in set (0.00 sec)

Code Example 5

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

Learn ReactJs, React Native from akashmittal.com