Convert PHP unix timestamp to a MySQL date format

Posted on by

In PHP:

$mysqldate = date( 'Y-m-d H:i:s', $unixdate );
$unixdate = strtotime( $mysqldate );

In the MySQL query:

$query = "UPDATE table SET
    datetimefield = FROM_UNIXTIME($phpdate)
    WHERE...";
$query = "SELECT UNIX_TIMESTAMP(datetimefield)
    FROM table WHERE...";

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>