MYSQL timestamp problems

The problem with timestamp and MYSQL is as follows. My database stores the timestamp. how can I obtain the timestamp's date and time directly using MYSQL statements? You do not need to use the following methods: foreach ($ dataas $ k = & gt; $ v) {& nbsp; $ data [$ k] ['about timestamp and MYSQL
Yes. The timestamp is stored in my database.
How can I obtain the date and time of this timestamp through MYSQL statements?
The following method is not required:
Foreach ($ data as $ k => $ v ){
$ Data [$ k] ['Time'] = date ('Y-m-d H: I: S', $ v ['Time']);
}

------ Solution --------------------
SELECT FROM_UNIXTIME (1234567890, '% Y-% m-% d % H: % I: % S ')
------ Solution --------------------

SQL code

SELECT FROM_UNIXTIME ('time') as 'time' FROM tablename;