mysql date woes help help help help

below is the ouput of my select query

'AARTIDRUGS', 'EQ', 68.00, 68.00, 63.55, 64.15, 63.75, 67.20, 8452.00, 549542.85, '22-Feb-07


the last column which appears to be date is varchar(45)

i want to convert this last column into date format of my sql and insert in a different table.

i want a select query

and update query

 

Then do a http://us2.php.net/str_to_time on the date and convert it to a unix timestamp and update it.

 

its a way but i want a simpler way by which i can do it

i want the qrey statemnets also written

 

use a combination of substring() and case when then when then ... to create an expression to parse your date. You need to covert the date to the YYYY-MM-DD format string, then MySQL will recognize it. Read MySQL manual on those functions for more info.

 

yeah thats what i did

thanx