How to change the field format?

Question

MySQL

You need to make an export from the old database and import it to the new site. The table has a field "year", which has the value of the year of manufacture. This is a four digit number. On the front on the current site, it is displayed like this, but in the database it is stored in this form:

Bigint field format. How can I translate this number into human readable? I will do the export to CSV and then import it to another site.

Answer 1

create a new column in the table with the date type, copy the values ​​into it in the required format as suggested by Maxim Fedorov , delete the old column, rename the new one.