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>