12
Hmmmm ... maybe the function UNIX_TIMESTAMP won't work on a varchar column.
Plan B:
Change the column type back to "datetime".
Rename the column to "olddate".
Add a new column "date" of type "int".
UPDATE table SET date = UNIX_TIMESTAMP(olddate)
I'd try this myself, but am too tired for that tonight.