Converting TIMESTAMP to DATETIME

Databases
1

Hi all,

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.

2

back up your table and then run this –

ALTER TABLE test5
CHANGE COLUMN foo foo DATETIME