July 2nd, 2013, 04:06 AM
what I would do first is
1. create another column called dispatchdate_test (or something) with Date as the type.
2. do a query such as :
set dispatchdate_test = select concat ( substr('get year') "/" substr(get month) "/" sub str "get date")...
I know my mysql is a bit sketchy but this is one way.
another way would be to use php to do a select
1. select primary_key, dispatch_date from.... table
2. go through the result
modify the dispatch_date by exploding on "/" and re-arranging it as yyy/mm/dd
create array[primary_key] and set the modified version to it
3. do another query (using a foreach loop of the array above) this query will update the table based on primary key and modified date (but use a new column first to make sure dates look the same, when you are happy delete the old column and then rename this new column