I have a table that has a time stamp value that is set as a varchar.
I have created another table with a date value, I want to to convert the time stamp value into a date format and insert the rows into the new table.
Below is the statement I have written. I assumed by converting to a "DATE_FORMAT the receiving table would except the rows.
INSERT INTO tblCards_Status (TransferStatus)
SELECT DATE_FORMAT(TransferStatus, '%d/%m/%Y') AS TransferStatus
WHERE TransferStatus IS NOT NULL
ORDER BY TransferStatus DESC
I am getting the following error message
Error Code: 1292. Incorrect date value: '31/10/2012' for column 'TransferStatus' at row 1