mysql convert timestamp to formatted date code example

Example: mysql convert timestamp to date

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

%H:%i:%s