I am converting an existing database for use with a new script, problem is the new script uses the DATETIME format while the old database stores the time in TIMESTAMP format. Is there a way to convert the field data from TIMESTAMP into DATETIME with a MySQL query?
Thanks a lot, your help is greatly appreciated.
back up your table and then run this --
ALTER TABLE test5
CHANGE COLUMN foo foo DATETIME