Mysql Q about dates in a varchar field

Soldato
Joined
4 Jul 2004
Posts
2,647
Location
aberdeen
Hi,
I have a massive table with dates in a varchar field like
01-feb-2009 (they are all like that)

Is there any way to convert it to a date field without losing any data and so i can order it correctly by date?

thanks
 
Back
Top Bottom