To convert a year-week to a date, then you should also specify the weekday: : STR_TO_DATE « Date Time Functions « MySQL Tutorial






mysql>
mysql>
mysql> SELECT STR_TO_DATE('200442 Monday', '%X%V %W');
+-----------------------------------------+
| STR_TO_DATE('200442 Monday', '%X%V %W') |
+-----------------------------------------+
| 2004-10-18                              |
+-----------------------------------------+
1 row in set (0.00 sec)

mysql>








14.39.STR_TO_DATE
14.39.1.STR_TO_DATE(str,format)
14.39.2.SELECT STR_TO_DATE('00/00/0000', '%m/%d/%Y');
14.39.3.SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y');
14.39.4.To convert a year-week to a date, then you should also specify the weekday: