How to change VARCHAR type to DATETIME using ALTER in MySQL?

alter-table, datetime, mysql, sql-update, varchar

Solution

ALTER TABLE <tblName> MODIFY <columnName> dataType constraint;

For your requirement it will be

ALTER TABLE <tblName> MODIFY <columnName> datetime;

Refer http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Problem

How can I change `VARCHAR()` type to `DATETIME` using `ALTER` in MySQL?

Original source