How to convert table from timestamp to datetime in phpmyadmin?

Question

MySQL

There is a database, it has a date field , in this field there are entries like: 1204298096, that is, in timestamp format, as far as I understand. There are more than 10 thousand such records.
It is necessary to convert these dates into datetime format like: 0000-00-00 00:00:00, this is ideal, but minutes and seconds can be trimmed if necessary, the main thing is year-month-day-hour ...
How to implement this?

Answer 1

The problem was solved on another forum. Might be useful to someone:

ALTER TABLE rdle_post MODIFY date VARCHAR(19);
UPDATE rdle_post SET date=FROM_UNIXTIME(date);
ALTER TABLE rdle_post MODIFY date DATETIME;