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.