Re: how to take advantage of STR_TO_DATE

[Felix Geerinckx]

gimi@stripped (Gilles MISSONNIER) wrote in
news:Pine.LNX.4.63.0701111127360.5910@ style="color:#666">stripped: 

> I rewrite my question in a simpler (?) way :
> How could I load in the database, data from a text file containaing
> date in a NOT MySQL standard date format [precisely char(10)], so that
> I get the date into a MySQL standard date format in a column of type
> "date" ? 

1. Load your dates in a thedate CHAR(10) column.
2. Then UPDATE foo SET thedate = STR_TO_DATE(thedate, '%d/%m/%Y');
3. Then ALTER TABLE foo MODIFY COLUMN thedate DATE;