how to convert a timestamp to date mysql in select code example

Example 1: mysql timestamp to date

-- Use the FROM_UNIXTIME() function in MySQL
select from_unixtime(timestamp) from my_tbl;

Example 2: mysql convert timestamp to date

DATE_FORMAT(FROM_UNIXTIME(`timestamp`), '%Y-%m-%d') AS 'send_date',

%H:%i:%s