DaemonForums - View Single Post - Convert varchar () to datetime datatype in MYSQL

anemos · #2 **(View Single Post)** 22nd June 2009

Code:

mysql> SELECT STR_TO_DATE('Wed Jun 17 12:06:00 2009', '%W %M %d %T %Y');
+-----------------------------------------------------------+
| STR_TO_DATE('Wed Jun 17 12:06:00 2009', '%W %M %d %T %Y') |
+-----------------------------------------------------------+
| 2009-06-17 12:06:00                                       |
+-----------------------------------------------------------+
1 row in set (0.00 sec)

Link