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

mysql datetime sql-update varchar alter-table
aizaz picture aizaz · Mar 11, 2013 · Viewed 41k times · Source

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

Answer

Meherzad picture Meherzad · Mar 11, 2013 
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

Related questions

When running UPDATE ... datetime = NOW(); will all rows updated have the same date/time?

When you run something similar to: UPDATE table SET datetime = NOW(); on a table with 1 000 000 000 records and the query takes 10 seconds to run, will all the rows have the exact same time (minutes and seconds) or will they have different …

Read More
How do you set a default value for a MySQL Datetime column?

How do you set a default value for a MySQL Datetime column? In SQL Server it's getdate(). What is the equivalant for MySQL? I'm using MySQL 5.x if that is a factor.

Read More
Should I use the datetime or timestamp data type in MySQL?

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP on the server side.

Read More