How to convert unixtime date into classic date in mysql?

When you have the unixtime date then you must create a SQL calculated field in order to transform classic date.
For this, use the following formula:FROM_UNIXTIME (My Date Field).