Answers for "php convert mysql timestamp to date"

php timestamp to date

<?php 
echo date('m/d/Y H:i:s', 1541843467); 
?>

mysql timestamp to date

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

convert timestamp to date php

<?php
$date = new DateTime();
echo $date->format('U = Y-m-d H:i:s') . "\n";

$date->setTimestamp(1171502725);
echo $date->format('U = Y-m-d H:i:s') . "\n";
?>