Change DateTime from mySql to timestamp in php

Question

In my mysql database dateTime is stored in the following form.

00000-00-00 00:00:00

In my php I want to convert it to tiemStamp form like this.

136716425

I tried using

$date2->getTimestamp();

without success, what function should I use to change the format to timestamp?

$sql = "SELECT * FROM temp_user";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {

    $date1 = new DateTime();
    $date2 = $row[dateTime];

    echo $date1->getTimestamp();
    echo $date2->getTimestamp();



}

[duplicate](http://stackoverflow.com/questions/4577794/how-to-convert-mysql-time-to-unix-timestamp-using-php) — Frédéric Clausset, Apr 28 '13 at 16:01

John Woo · Accepted Answer · 2013-04-28T16:06:05.120

4

MySQL has a builtin function for that called UNIX_TIMESTAMP

SELECT UNIX_TIMESTAMP(NOW())

UPDATE

$sql = "SELECT *,UNIX_TIMESTAMP(dateTime) unx FROM temp_user";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) 
{
    $var = $row['unx'];
    // other codes
}

edited Apr 28 '13 at 16:06

answered Apr 28 '13 at 15:57

John Woo

258,903
69
498
492

Have updated with a code sample. Not sure how I would integrate what you have posted here into that code, as I'm selecting more then just date from SQL. – Philip Kirkbride Apr 28 '13 at 16:04

Change DateTime from mySql to timestamp in php

1 Answers1