Re: Mysql updating dates in a table

> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
> You can use Str_to_date to convert it to a date.
> Date/timestamp data should be one of the date types (Datetime, date,
> timestamp).
> I'd do it like this (all sql and won't lose data):
>      1. Add a column to the table that is date/datetime/timestamp (in
>         your case date looks right)
>      2. update the new column using the str_to_date function
>      3. Check for rows that have nulls in that column - fix them
>      4. set the existing column value to NULL
>      5. change the column to a date using alter table.
>      6. update the column to be whatever you called the new column you
>         added.
>      7. Drop the new column that you added.
>      8. add not null constraint to your original date column