Convert varchar () to datetime datatype in MYSQL

[cksraj]

Hi dudes

I have a varchar something like this 'Wed Jun 17 12:06:04 2009' I would like to store into my MySql database. How to convert this varchar to datetime datatyep? Just guide me...

Thanks
Raj

[anemos]

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