I need to create a mysql query that will convert a field from string to date. The string originates from an email which takes the value and inserts into the table. The data is always in this format;
Tue Oct 04 19:01:43 2011
How can I convert this to a date that would match mm/dd/yy in my query?
Thanks in advance.