Answers for "mysql string to timestamp"

mysql convert timestamp to date

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

%H:%i:%s

Posted by: Guest on March-23-2021

string to datetime php

$s = '06/10/2011 19:00:02';
$date = strtotime($s);
echo date('d/M/Y H:i:s', $date);

Posted by: Guest on May-25-2020

Datetime to string php

<?php
$date = new DateTime('2000-01-01');
echo $date->format('Y-m-d H:i:s');
?>

Posted by: Guest on March-30-2020

mysql timestamp to date

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

Posted by: Guest on October-14-2020

Code answers related to "mysql string to timestamp"